Mass importing products into eStore

[einfohound]

I found the plugin and template for mass importing items into eStore. It works just like you described. I actually added onto the template to include the rest of the fields (columns) that were not there – so now I can set everything.

I have one problem though that, for me, makes using this process almost worthless. I need each product in my system to be assigned to a category. But since this is not handled via a field in this table, I cannot set it using this mass import process. This means that, after I do the import, I have to manually edit each product and set the category. This makes the process just as long as if I manually copy an existing product and add the new one. So being able to import ends up not saving me any time in the long run.

A possible way around this would be for me to run an SQL query after I have done the import to set the category for all the products I just imported. As an example, a group of products would be named like this “weight-loss-xxxxxxxxxx” (where xxxxxxx would be variable). These would all be assigned to category “Weight Loss” (or I can find the category number for that category).

Can you provide me with the SQL query that I could use to accomplish this? I add a couple hundred products at a time, and being able to do this would save me lots of time.

[admin]

I have added a new section called “Assigning Category To Your Bulk Uploaded Products” in the following documentation which should help you:

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

[einfohound]

Thanks! That will work great. Actually, I should have stopped and thought a minute and I could have figured out that I could have used this same process – duh!!

[MagicTH]

RE: The webpage referenced above …-775

The instructions on the last part for assigning categories has several flaws, probably due to changes in the last 5 years on how WP works. I believe I found my way through all that, yet the category assignment fails.

I have verified my .csv file is 100% correct (I made a test file with only 3 digital download products). Verified the Product IDs, tried assigning them to category 2 (which I already created and verified). It keeps failing with the error “Starting row value exceeds the number of entries…”. On Select Input File it shows 4 columns. There are 4 ROWS, not columns. At the bottom the preview correctly shows 2 columns.

Sounds like a bug to me. I’m using WP 4.8. It doesn’t matter if I check “Update Database Rows” or not. Instructions don’t mention it, but they are existing products so it seems it should be checked.

I have screen shots with more detail if you like, along with the additional instructions I think are needed.

Please advise. In the meantime I will try to use SQL in PHP Admin if I have it.

[wzp]

Please post links to your screenshots; particularly a (read only) view of the CSV file.

[Author]

Posts