Hi,
I already have one website running and want to copy the same products to new one so I went through documentation and followed the steps but csv file is not coming in expected format and the csv file I have from old project is different please help me merge it and import it..
I am getting this error "Incorrect structure of main Array node. Only table nodes are expected"
Thanks
Hello.
What do you mean "is not coming in expected format"?
Also check Cart migration tool it may help with few carts http://docs.abantecart.com/pages/tools/migration.html
I am running locally as of now so I have two stores
In one store I have entered all products manually and in other I have used extension > Import method where I have exported the products.csv and categories.csv and pasted in the new products it was successfull but I couldn't get the images
P.S I have copied images from old project to the new ones at the new destinations
Hello.
AbanteCart store images in Resource Library so you need to export RL too. Additionally you can move your store in other way see http://docs.abantecart.com/pages/tips/change_domain.html#ChangeHosting
I have still had zero success importing products through the AbanteCart CSV/TXT/XML Importer. I have thousands more to do and need to figure out what I'm doing wrong. It'll give me a count of successful queries and listings created, but then I always get an error and it seems to knock each row (line item, listing) out and I end up with no change to Inventory or Database when checking phpMyAdmin. These are the latest error messages I'm getting:
Missing relation ID category_id for update_or_insert action in table products_to_categories. Skipping.
Missing relation ID category_id for update_or_insert action in table products_to_categories. Skipping.
Missing relation ID category_id for update_or_insert action in table products_to_categories. Skipping.
...
Can you post import file sample? Include only 2-3 records in the sample.
Thank you for your reply. I figured out the problem to this particular issue and will share my conclusion for the benefit of the community. I exported a full product (meaning every product table) CSV from the admin panel. Thus there were multiple "product_id" columns in the spreadsheet, ordered as they appeared in certain tables (i.e. _product_description table has a product_id column, as does _product_categories, and so on). The real mistake I made was filling in the product_id column that was part of the "products to categories" table with our id numbers, but not having a associated category id to all of the product ids listed. Hence the error message. I went back and corrected this and the upload was successful, even though prices and dates were off because I used Excel. Trial and error, lol.