CSV Import and Product Category

[gamehermit]

Hi Everyone,

I’m setting up my CSV for import but don’t see the “Product Category” in the CSV or the Header Text file. Any ideas?

Thanks,

Jack

[gamehermit]

Got It!!!

I imported all my products (without Category IDs). Once the products were imported, I used PHPMyAdmin to export the products table to get the prod_id values that were auto assigned by the cart. Then I assigned the category number to each product in a spreadsheet with the headers cat_id (for the category) and prod_id (product ID from the product table export). I exported this as a CSV and used WP CSV To DB to import the data to the table named “wp_wp_eStore_cat_prod_rel_tbl” and set this as the “Database Column Names” –> cat_id,prod_id. Hit the magic button and TADAAA….done

You have the easiest cart to work with!!!! Love it

Jack

[Susnos]

Thanks for the hint! I was just getting nuts for not being able to assign the products a category in my CSV! I not using WP CSV, just export and import using PHPMyAdmin. So when I have imported my products, I just export them to get the product ID. Then I can fill in the DB tbl. “wp_wp_eStore_cat_prod_rel_tbl” and assign them with the proper category ID! Love it! Thanks for the head up!

[gamehermit]

You bet

[sucha]

Hi

How can I e-commerce plugin applied products be imported to the e-store plugin?

Thx,

Sucha

[admin]

I am not a 100% sure as to what you mean but I think this video will help you:

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

[sucha]

Thanks for the quick reply! Sorry, I try to formulate more precisely. So far, the free WP eCommerce plugin I used on my site. I bought the eStore plugin, and I did it. Unfortunately, it did not take over the previously established categories and products. I would not again be applied manually, so seeking a practical solution.

Thx

Sucha

[admin]

Thank you for the explanation. There is no one click button that will import your other e-commerce plugin’s data into eStore.

You will need to export the product data from your other plugin’s database table and then format it in the way eStore needs and import it into eStore’s table.

The above mentioned video tutorial and the following post should help you some:

http://www.tipsandtricks-hq.com/ecommerce/how-to-bulk-upload-estore-products-from-a-csv-file-775

[sucha]

Thx, I try it!

[Author]

Posts