menu

Help : BACKOFFICE : Import/Export : Product Table

Video

  • 60+ videos dealing with more complex topics are available for free on YouTube

Help : BACKOFFICE : Import/Export : Product Table

  • For help, scroll through the below BackOffice topics and then click on desired topic, or click here

Help : BACKOFFICE : Import/Export : Product Table

  • AttributeTypeDescription
    ida64 CharAlphanumeric Identity aka SKU
    Note: ida cannot contain commas or semi-colons
    Example: car-bmw-130i-white-a1b1c1
    ido64 CharProduct Options Identity
    That is, all the products belonging to the same group of options
    Example: car-bmw-130i-white
    ean64 CharEuropean Article Number
    (also known as International Article Number) is a unique 13 digit number used in barcodes to identify a specific retail product type, in a specific packaging configuration, from a specific manufacturer.
    Example: 9712037212572
    state[-1, 7] IntProduct State
    -1means delete
    0means blocked
    1means standard
    2means special offer
    3means new
    4means reserved
    5means rental
    6means contact
    7means bargain
    Example: 1
    t0ISO DateStart Date of special offer or new product
    Example: 2007-08-01
    t1ISO DateEnd Date of special offer or new product
    Example: 2007-08-31
    stockSigned IntStock
    0means out of stock
    0 < #means this many are in stock
    # < 0means unlimited stock
    Example: 47
    stockt=   +   -Stock Type
    Stock Type allows adding the value of the various stock in three different ways to the current stock during import:
    =means overwrite the current stock
    +means add to the current stock
    -means decrease from the current stock
    Example:
    Stock in shop is currently 35
    Import stock = 15
    Stocktequals=i.e. new stock = 15
    Stocktequals+i.e. new stock = 50 = 35 + 15
    Stocktequals-i.e. new stock = 20 = 35 - 15
    sortPositive IntSort Product
    Position the product among the other products of the same category
    Example: 9
    cidVarcharCategory Identities
    A product needs to be attached to at least one category. But you may attach a product up to a maximum of 30 categories. The category identities start at 100.
    Note: YourShop guarantees perfect product indexing only for products which are attached to a single category
    Example: 165,348,520
    wcomsortInt & BlankWelcome Sort
    This field allows adding a product to the welcome page and sorting it among the other welcome page products
    Blankmeans the product is not added
    0means the product is added and alphabetically sorted
    0 < #means product is added at position #
    Example: 3
    brandInt & BlankProduct Brand
    Blank means the product is not associated to a brand
    To associate a product to a brand, mention the brand's identity
    Example: 19
    yiam[0, 3] IntYes I Am
    Activating this option asks for the customer's age during checkout. Use it for restricted products:
    0means standard product, the age is not asked
    1means alcohol
    2means spirit
    3means tobacco
    Example: 1
    wrVarcharWrite a Review
    Write a Review can only be exported
    Write a Review contains a summary of reviews a product has received
    The wr record #:#:#:#:#:#:#:# consists of 8 numbers which are separated by a colon:
    1st #means average
    2nd #means number of 1 star reviews
    3rd #means number of 2 stars reviews
    4th #means number of 3 stars reviews
    5th #means number of 4 stars reviews
    6th #means number of 5 stars reviews
    7th #means number of reviews
    8th #means number of comments
    Example: 4.6:0:0:1:0:4:5:2
    pes[1, 11] & BlankProduct Element Sort
    Organise how elements show on the product page:
    Blankmeans sort according to global setting specified in [TOOLS] -> [Shop Behaviour]
    1,2,3,4,5,6,7,8,9,10,11means sort according to position
    The numbers correspond to these elements:
    1 ==Product 2nd Description
    2 ==Product Details
    3 ==Product Options
    4 ==Explanation of how a product with file Download works
    5 ==Field to ask Customer for some text
    6 ==Product Video
    7 ==Product Table
    8 ==Explanation of how a product with file Upload works
    9 ==Quantity Discount
    10 ==Rental
    11 ==Write a Review
    Example: 11,1,2,3,4,5,6,7,8,9,10 shows Write a Review in first place
    name96 CharProduct Name
    Example: BMW 130i white
    descr1tit128 Char1st Product Description Title
    If the field is blank YourShop writes by default:
    Product description
    descr16'144 Char1st Product Description
    If the field is blank YourShop does not show the above title, descr1tit, either
    You can enhance the 1st product description with the following HTML TAGS: [br], [h4], [/h4], [b], [/b], [i], [/i], [span], [/span], [div], [/div], [ul], [li], [/li], [/ul], [table], [tr], [td], [/td], [/tr], [/table]
    Example: You will surely love this adorable puppy!
    descr2tit128 Char2nd Product Description Title
    If the field is blank YourShop writes by default:
    2nd Product description
    descr212'288 Char2nd Product Description
    If the field is blank YourShop does not show the above title, descr2tit, either
    You can enhance the 2nd product description with the following HTML TAGS: [br], [h4], [/h4], [b], [/b], [i], [/i], [span], [/span], [div], [/div], [ul], [li], [/li], [/ul], [table], [tr], [td], [/td], [/tr], [/table]
    Example: This watch brings back memories of the 70s
    img1100 Char1st Thumbnail
    The 1st thumbnail is only shown in professional picture mode, otherwise the 1st thumbnail is created from the 1st product picture in easy and quick picture mode.
    The size must be within [40 - 120] x [40 - 120] pixels
    The best width is 90 pixels
    Permitted picture formats are: gif, jpg, png, and webp
    Example: car-bmw-130i-white-1st-thumb.jpg
    img2100 Char2nd Thumbnail
    Similar to 1st thumbnail
    The size must be within [60 - 200] x [60 - 200] pixels
    The best width is 140 pixels which is for mobile phones
    Example: car-bmw-130i-white-2nd-thumb.jpg
    img3100 Char3rd Thumbnail
    Similar to 1st thumbnail
    The size must be within [100 - 280] x [100 - 280] pixels
    The best width is 200 pixels
    Example: car-bmw-130i-white-3rd-thumb.jpg
    imgn30 * 100 CharMax 30 pictures
    The pictures are comma separated
    Most parameters are similar to 1st, 2nd, and 3rd thumbnail
    Allowed sizes are within [220 - 1200] x [220 - 1200] pixels
    Example: car-bmw-130i-white-pic1.jpg,car-bmw-130i-white-pic2.jpg,car-bmw-130i-white-pic3.jpg,car-bmw-130i-white-pic4.jpg
    annexn64 CharLink name of supplementary file annexv
    Example: Product Specifications PDF 1MB
    annexv32 CharFile name of supplementary file
    Maximum file weight 3MB
    Example: product-specifications.pdf
    downld32 CharDownload File
    YourShop offers you the option to sell downloadable software, pictures, music or other downloadable informational items in a file.
    Maximum file weight 4MB
    The customer cannot access the download file if payment has not been successfully completed. YourShop provides a specially crafted and unique link for every download file in the checkout confirmation HTML page, and then sends this link in the confirmation email. The link stays valid for the next 3 days and is then no longer accessible
    Example: painkiller.mp3
    tlic64 CharTemporary Licence
    If necessary, write a temporary licence for the above download
    Example: LIC1984
    licence[0, 2] IntProduct Licence
    0means product has no licence
    1means product has a licence and the licence is bound to the product's ida
    2means product has a licence but the licence is not bound to the product's ida
    Note: import licences with the file import-licence.txt
    Example: 1
    upload± [0, 5] IntCustomer File Upload
    Customer can upload up to 5 files during checkout
    The upload is:
    Mandatory for positive numbers
    Optional for negative numbers
    Maximum file weight 5MB
    Example: -3 that is the customer can upload up to 3 files during checkout
    linkn32 CharLink Name
    Example: YourShop POS
    linkv128 CharLink URL
    Example: https://YourShop.com/
    labtit64 CharProduct Details Title
    Example: Details
    labn30 * (64 + 1024) CharProduct Details
    This is a list where # separates different details and ; separates name and value like this: name;value#name;value#...
    There can be maximum 30 different details
    The name can be maximum 64 characters long
    The value can be maximum 1024 characters long
    Example: Year;2006#Mileage;7'000 Km#...
    ctext128 CharCustomer Text
    Ask customer for an answer
    Example: What text shall be embroidered on the socks?
    opttit64 CharProduct Options Title
    Example: Options
    optn30 * (32 + 224) CharProduct Options
    This is a list where # separates different options and ; separates option name and option possibilities like this: name;opt1;opt2;opt3#name;opt1;opt2#...
    There can be maximum 30 different options
    The option name can be maximum 32 characters long
    The option possibilities can be maximum 224 characters long
    An option possibility can influence the product price like this:
    :+#increases the product price by #
    :-#decreases the product price by #
    :*#multiplies the product price by #
    Example: Colour;Red;Blue;Black#Turbo;No;Yes:+2500.00
    If your shop counts stock individually then there is no need to add a price modification to an option possibility. If you would like the customer to see how the option possibility changes the price, add the price like this (+#) e.g. (+2500.00)
    Example: Colour;Red;Blue;Black#Turbo;No;Yes (+2500.00)
    tabtit64 CharProduct Table Title
    Example: Table
    tabn30 * 30 * 1024 CharProduct Table Cells
    This is a list where # separates rows and ; separates cells like this: cell.1.1;cell.1.2;cell.1.3#cell.2.1;cell.2.2;cell.2.3;#...
    There can be a maximum 30 rows and 30 cells per row
    A cell can be a maximum 1024 characters long
    Blank cells are possible e.g. ;;; creates 2 blank cells
    Example: Carbohydrates;Fat;Fibres#75g;12g;7g#...
    tabb[0,3] IntProduct Table 1st row and/or 1st column bold
    0means nothing is bold
    1means 1st row is bold
    2means 1st column is bold
    3means both, 1st row, and 1st column are bold
    Example: 2
    videotit64 CharVideo Title
    Example: Video : Pacha the Doberman
    video1024 CharYouTube video
    Example: HnSgBXoU12c
    videoa[0, 1] IntVideo Automatic Start
    0means video does not start playing automatically
    1means video starts playing automatically
    Example: 0
    renttit64 CharRental Product Title
    Example: Rent a chainsaw
    quarant[0, 365 * 86400] IntRental Product Quarantine
    This is the product unavailability duration after drop-off, maximum 365 days expressed in seconds
    Example: 86400 which is one day
    depo[0.00, 999'999.99]Rental Product Deposit
    Example: 1500.00
    weight[0.000, 99'999.999]Product Weight in kg
    Example: 0.5 means 500g
    packing± [0.00, 999'999.99]Product Package Fee
    0means no package cost
    0 < #means package must be paid for each product
    # < 0means pay package only once even for several products
    Example: -17.50
    gwrap[0, 1] IntProduct Gift Wrap
    0means product cannot be gift-wrapped
    1means product can be gift-wrapped
    Example: 1
    gwrapcost± [0.00, 9'999.99]Product Gift Wrap Cost
    0means gift wrap is free
    0 < #means gift wrap must be paid for each product
    # < 0means pay gift wrap only once even for several products
    Example: -7.80
    gnote[0, 1] IntProduct Gift Note
    0means product cannot have a gift note
    1means product can have a gift note
    Example: 1
    gnotecost± [0.00, 9'999.99]Product Gift Note Cost
    0means gift note is free
    0 < #means gift note must be paid for each product
    # < 0means pay gift note only once even for several products
    Example: 5.50
    deliservVarcharDelivery Service
    Blank meansthe product can be delivered by any delivery service
    or alternatively,the product's required delivery services must be listed with the colon separated
    Example: 3:5:7
    Note: The mentioned delivery services must be known in the system
    price[0.00, 999'999.99]Product Price
    Example: 250.75
    promo[0.00, 999'999.99]Special Offer Price
    Example: 99.99
    arf[0.00, 999'999.99]Advanced Recycling Fees
    Example: 2.80
    vat[0.000, 99.999]VAT
    0 means no vat
    alternatively, percentage without the % sign
    Example: 7.7
    boxqty[0, 1] IntBox Quantity
    0means box quantity does not apply to this product
    1means this product can form a multiple together with other products in the same box
    Example: 1
    qtyminPositive IntMinimum Purchase Quantity
    Customer cannot buy less than this many products
    Example: 6
    qtystepPositive IntPurchase Quantity Increment
    To buy more than the minimum purchase quantity, suggest an increase on a fixed scale
    Example: 6
    qtymaxPositive IntMaximum Purchase Quantity
    0 means unlimited
    or limit it by putting a multiple of the Increment N * qtystep
    Example: 36
    qtydiscVarcharMax 30 Quantity Discounts
    There are two types of discounts:
    %means percentage based discounts
    #means amount based discounts
    Discounts are written like this:
    Type;Threshold1/Discount1;Threshold2/Discount2;...
    Example Percentage: %;5/3.3;10/10;20/30
    Example Amount: #;5/2.50;10/10.00/20/50.00
    unit32 CharProduct Unit
    You may add a unit
    Example: per kg when offering tomatoes
    avail32 CharProduct Availability
    Inform your customers about the availability of a product by entering that information
    Example: within 3 days

Support

  • If you cannot find an answer to your query in the YourShop videos or in the YourShop help guides, contact us by phone on +41 21 67 17 111 or by email
Support

Tech News

  • Follow the developments of YourShop on X or on our News page.
Tech News

Become a YourShop fan

Become a YourShop fan
Speed Sells Choose an offer
X
 X