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.
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.
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.
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)
You must log in to post.
