Author Topic: Import data with images  (Read 6339 times)

Offline tomgormley08

  • Newbie
  • *
  • Posts: 7
  • Karma: +1/-0
    • View Profile
Import data with images
« 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.

 

Offline Basara

  • Administrator
  • Hero Member
  • *****
  • Posts: 5774
  • Karma: +274/-2
    • View Profile
Re: Import data with images
« Reply #1 on: March 24, 2020, 11:38:12 PM »
Please upload example of CSV file

Offline tomgormley08

  • Newbie
  • *
  • Posts: 7
  • Karma: +1/-0
    • View Profile
Re: Import data with images
« Reply #2 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.

Offline tomgormley08

  • Newbie
  • *
  • Posts: 7
  • Karma: +1/-0
    • View Profile
Re: Import data with images
« Reply #3 on: March 26, 2020, 04:18:25 AM »
This is a sample file for the Example 4:  method which didnt work.

Offline Basara

  • Administrator
  • Hero Member
  • *****
  • Posts: 5774
  • Karma: +274/-2
    • View Profile
Re: Import data with images
« Reply #4 on: March 27, 2020, 02:49:04 AM »

Offline anewagephoenix

  • Newbie
  • *
  • Posts: 4
  • Karma: +2/-1
  • Temper us in fire, and we grow stronger.
    • View Profile
Re: Import data with images
« Reply #5 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.

 
AbanteCart Version 1.2.16

 

Powered by SMFPacks Social Login Mod