Importing (Price 1,2,3,4)

Posted by HackSwiTcH 
Welcome! Log In Create A New Profile Search
Importing (Price 1,2,3,4)
May 31, 2018 10:44PM
Hi, I am having trouble with importing Products and need more info on what (Price) goes where on the import sheet. The guide is in German, I only speak English. Can you clarify price 1, 2, 3, 4...
I have my (Cost) and need to input into the right field.
Also what columns on the (Product Import) are required?

Thanks in advance! Great program!!
_________
Hallo, ich habe Probleme mit dem Import und benötige weitere Informationen darüber, welcher Preis wohin auf dem Importblatt geht. Der Führer ist auf Deutsch, ich spreche nur Englisch. Können Sie den Preis 1, 2, 3, 4 klären?
Ich habe meine (Kosten) und muss in das richtige Feld eingeben.
Auch welche Spalten auf dem (Product Import) werden benötigt?

Danke im Voraus! Tolles Programm !!
Re: Importing (Price 1,2,3,4)
May 31, 2018 11:04PM
Hi HackSwiTcH,

Quote

The guide is in German, I only speak English.
... Therefore we've an English forum smiling smiley

Quote

Can you clarify price 1, 2, 3, 4...
I have my (Cost) and need to input into the right field.
Also what columns on the (Product Import) are required?

The prices are scale prices. I.e., for 1 unit you have to pay 10$, for 100 units only 8.34$ per unit etc. The following columns are required for import:

  • itemnr ... item number
  • name ... the name of that product
  • category ... a category to which this product belongs to (e.g., "Shop" or "Personal tools" )
  • description ... a description for this product
  • price1 ... net price for 1st scale
  • price2 ... net price for 2nd scale
  • price3 ... net price for 3rd scale
  • price4 ... net price for 4th scale
  • price5 ... net price for 5th scale
  • block1 ... quantity, where the first scale starts (e.g.: 1 for a scale from 1 to 9).
  • block2 ... quantity, where the 2nd scale starts (e.g.: 10 for a scale from 10 to 99).
  • block3 ... quantity, where the 3rd scale starts (e.g.: 100 for a scale from 100 to 999).
  • block4 ... quantity, where the 4th scale starts (e.g.: 1000 for a scale from 1000 to 9999).
  • block5 ... quantity, where the 5th scale starts (e.g.: (z.B.: 10000 for a scale from 10000 up).
  • vat ... VAT, e.g. 0.19 for a VAT of 19%
  • options ... currently unused, please leave it empty
  • weight ... weight of this product
  • unit ... currently unused, please fill ist with -1
  • date_added date of creation for this product (you can leave it empty)
  • picturename ... the name of the product picture, e.g.: SAMPL03_Poti_100k.jpg
  • quantity ... stock quantity
  • webshopid ID ... web shop ID or -1 if unused
  • qunit ... quantity unit (lb, oz etc.)

Kind regards,

Viele Grüße,
Ralf.
Re: Importing (Price 1,2,3,4)
June 28, 2018 10:03PM
Ralf, Thanks so much for the breakdown! I got everything importing now. I'm getting images for our 1300 products and matching them to the fields.

One Question.
Will the field Picture- take a URL instead of a .jpg?
(picturename ... the name of the product picture, e.g.: SAMPL03_Poti_100k.jpg)

Thanks again!
Re: Importing (Price 1,2,3,4)
June 29, 2018 08:26AM
Hi,
the picture has to contain an image name or an relative URL to the picture, e.g. "images/SAMPL03_Poti_100k.jpg". The URL is build from your webshop URL (concatenation of webshop URL and image path).

Viele Grüße,
Ralf.
Sorry, only registered users may post in this forum.

Click here to login