import CSV file into wp estore with additional custom fields

[mmoore5553]

I need fields like this pulled and put into the wp estore

ProductID|Name|MerchantID|Merchant|Link|Price|RetailPrice|status|manufacturer

i Would love to have more if i can. Also is there a way to add a review or rating system ? I looked at the example CSV file and it has some of the info i need but want to add more. Can you give me some direction where to add this or get it started. Thank you.

[amin007]

You can only import data into eStore that the products table has database column for. Not all the data you mentioned is used in eStore (for example: merchant ID, status, manufacturer etc). Basically, you can go to the add/edit product menu and look at the data eStore lets you save for a product. Those are the fields you can import into eStore.

[Arthur]

Just getting started and need to use the import CSV for large product list.

Comparing the text file provided with the WP CSV to DB Plugin and the DB observed with phpMyAdmin the following fields are not in the text file but are in the DB:

item_spec_instruction

ppv_content

use_pdf_stamper

create_license

tax

author_id

show_qty

tier2_commission

custom_price_option

additional_images

old_price

rev_share_commission

If I understand your comment correctly

1. I can add these to the text file names and paste in WP CSV to DB Step 1 – Database Column Name box.

2. Add the data to my CSV file. And this data will upload as well.

I’m not much on using the DB, so I’ll be uploading a large product list and only want to make sure I can reduce the number of tweaks after it is upload.

Second item

If I add additional products via upload, It will only upload new products, It will not or can not override existing products, is that correct?

Third item

Is there any development to make the importer more robust to be able to edit my offline file to update on a mass scale? Or to edit the products by making changes more like a spreadsheet process rather than one product at a time.

Ask this because I don’t want to give my assistant access to the cpanel section of the host, to many things that could go wrong, so would like to control product changes in a master sheet. Any thoughts on the quickest easiest way to do this?

Thanks for your consideration.

[amin007]

Yes, your understanding is correct on item 1 and item 2. We are making an elaborate video tutorial on how to do this using the PHPMyAdmin tool (available to you via your cPanel). This tutorial will show you how you can do the operations that you are after on any WordPress table (including the eStore’s products table)

[Arthur]

Thanks for the validation. Looking forward to your video.

[amin007]

http://www.tipsandtricks-hq.com/how-to-easily-import-or-export-any-of-your-wordpress-database-content-using-phpmyadmin-3415

[JeffreyL]

Regards. “We are making an elaborate video tutorial on how to do this using the PHPMyAdmin tool”

Has the video been created yet? If yes you have a link.

Thanks

R:

Jeff

[JeffreyL]

I must be Zzzzzz’ing… Just saw the link.

Ignore my message.

R:

Jeff

[Author]

Posts