AbanteCart Community

Shopping Cart Operations => Documentations & Manuals => Topic started by: tomgormley08 on March 24, 2020, 10:04:11 AM

Title: Import data with images
Post by: tomgormley08 on March 24, 2020, 10:04:11 AM
Hi, There the instruction in Abantecarte User Manuals 1.2 re Example 4: Insert products with Images seems to be incorrect.

I get "Missing relation ID related_id for update_or_insert action in table products_related. Skipping.

if I export a product with an image and remove the resource_library[0][0].resource_id and resource_descriptions[0][0][0].resource_id and try to reimport it fails.

The jpg file name that is exported is not the one the I uploaded and attached to the product.

 
Title: Re: Import data with images
Post by: Basara on March 24, 2020, 11:38:12 PM
Please upload example of CSV file
Title: Re: Import data with images
Post by: tomgormley08 on March 25, 2020, 07:52:29 PM
I changed the format to use a URL path point to image file on the webserver which worked.
Title: Re: Import data with images
Post by: tomgormley08 on March 26, 2020, 04:18:25 AM
This is a sample file for the Example 4:  method which didnt work.
Title: Re: Import data with images
Post by: Basara on March 27, 2020, 02:49:04 AM
Try to not change the CSV delimiter. Use example in https://abantecart.atlassian.net/wiki/spaces/AD/pages/15007876/Import#Import-Example4:InsertproductswithImages
It is TAB delimeted file.

You can also check the Import Wizard https://abantecart.atlassian.net/wiki/spaces/AD/pages/16777227/Import+Wizard
Title: Re: Import data with images
Post by: anewagephoenix on June 07, 2020, 02:35:47 PM
Not sure if this helps,  before i do anything i go into my cpanel or ftp and make a file under the resources directory, name it what you want, i called my upload. i then upload into that file all the images i need.

Then i make my cvs file, under the image column  i point to the upload file, (resources/image/upload/toy.jpg)

Then i use the wizard to upload a file with all the headings, already present on my cvs file. ie., sku, id, description, etc,  the wizard with ask how you want those heading to appear in your store front.
The wizard will grab those pictures and put them where they need to be.