or click here| Attribute | Type | Description | ||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ida | 64 Char | Alphanumeric Identity aka SKU Note: ida cannot contain commas or semi-colons Example: car-bmw-130i-white-a1b1c1 | ||||||||||||||||||||||||||
| ido | 64 Char | Product Options Identity That is, all the products belonging to the same group of options Example: car-bmw-130i-white | ||||||||||||||||||||||||||
| ean | 64 Char | European 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] Int | Product State
| ||||||||||||||||||||||||||
| t0 | ISO Date | Start Date of special offer or new product Example: 2007-08-01 | ||||||||||||||||||||||||||
| t1 | ISO Date | End Date of special offer or new product Example: 2007-08-31 | ||||||||||||||||||||||||||
| stock | Signed Int | Stock
| ||||||||||||||||||||||||||
| stockt | = + - | Stock Type Stock Type allows adding the value of the various stock in three different ways to the current stock during import:
Stock in shop is currently 35 Import stock = 15
| ||||||||||||||||||||||||||
| sort | Positive Int | Sort Product Position the product among the other products of the same category Example: 9 | ||||||||||||||||||||||||||
| cid | Varchar | Category 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 | ||||||||||||||||||||||||||
| wcomsort | Int & Blank | Welcome Sort This field allows adding a product to the welcome page and sorting it among the other welcome page products
| ||||||||||||||||||||||||||
| brand | Int & Blank | Product 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] Int | Yes I Am Activating this option asks for the customer's age during checkout. Use it for restricted products:
| ||||||||||||||||||||||||||
| wr | Varchar | Write 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:
| ||||||||||||||||||||||||||
| pes | [1, 11] & Blank | Product Element Sort Organise how elements show on the product page:
| ||||||||||||||||||||||||||
| name | 96 Char | Product Name Example: BMW 130i white | ||||||||||||||||||||||||||
| descr1tit | 128 Char | 1st Product Description Title If the field is blank YourShop writes by default: Product description | ||||||||||||||||||||||||||
| descr1 | 6'144 Char | 1st 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! | ||||||||||||||||||||||||||
| descr2tit | 128 Char | 2nd Product Description Title If the field is blank YourShop writes by default: 2nd Product description | ||||||||||||||||||||||||||
| descr2 | 12'288 Char | 2nd 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 | ||||||||||||||||||||||||||
| img1 | 100 Char | 1st 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 | ||||||||||||||||||||||||||
| img2 | 100 Char | 2nd 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 | ||||||||||||||||||||||||||
| img3 | 100 Char | 3rd 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 | ||||||||||||||||||||||||||
| imgn | 30 * 100 Char | Max 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 | ||||||||||||||||||||||||||
| annexn | 64 Char | Link name of supplementary file annexv Example: Product Specifications PDF 1MB | ||||||||||||||||||||||||||
| annexv | 32 Char | File name of supplementary file Maximum file weight 3MB Example: product-specifications.pdf | ||||||||||||||||||||||||||
| downld | 32 Char | Download 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 | ||||||||||||||||||||||||||
| tlic | 64 Char | Temporary Licence If necessary, write a temporary licence for the above download Example: LIC1984 | ||||||||||||||||||||||||||
| licence | [0, 2] Int | Product Licence
Example: 1 | ||||||||||||||||||||||||||
| upload | ± [0, 5] Int | Customer 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 | ||||||||||||||||||||||||||
| linkn | 32 Char | Link Name Example: YourShop POS | ||||||||||||||||||||||||||
| linkv | 128 Char | Link URL Example: https://YourShop.com/ | ||||||||||||||||||||||||||
| labtit | 64 Char | Product Details Title Example: Details | ||||||||||||||||||||||||||
| labn | 30 * (64 + 1024) Char | Product 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#... | ||||||||||||||||||||||||||
| ctext | 128 Char | Customer Text Ask customer for an answer Example: What text shall be embroidered on the socks? | ||||||||||||||||||||||||||
| opttit | 64 Char | Product Options Title Example: Options | ||||||||||||||||||||||||||
| optn | 30 * (32 + 224) Char | Product 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:
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) | ||||||||||||||||||||||||||
| tabtit | 64 Char | Product Table Title Example: Table | ||||||||||||||||||||||||||
| tabn | 30 * 30 * 1024 Char | Product 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] Int | Product Table 1st row and/or 1st column bold
| ||||||||||||||||||||||||||
| videotit | 64 Char | Video Title Example: Video : Pacha the Doberman | ||||||||||||||||||||||||||
| video | 1024 Char | YouTube video Example: HnSgBXoU12c | ||||||||||||||||||||||||||
| videoa | [0, 1] Int | Video Automatic Start
| ||||||||||||||||||||||||||
| renttit | 64 Char | Rental Product Title Example: Rent a chainsaw | ||||||||||||||||||||||||||
| quarant | [0, 365 * 86400] Int | Rental 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
| ||||||||||||||||||||||||||
| gwrap | [0, 1] Int | Product Gift Wrap
| ||||||||||||||||||||||||||
| gwrapcost | ± [0.00, 9'999.99] | Product Gift Wrap Cost
| ||||||||||||||||||||||||||
| gnote | [0, 1] Int | Product Gift Note
| ||||||||||||||||||||||||||
| gnotecost | ± [0.00, 9'999.99] | Product Gift Note Cost
| ||||||||||||||||||||||||||
| deliserv | Varchar | Delivery Service
| ||||||||||||||||||||||||||
| 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] Int | Box Quantity
| ||||||||||||||||||||||||||
| qtymin | Positive Int | Minimum Purchase Quantity Customer cannot buy less than this many products Example: 6 | ||||||||||||||||||||||||||
| qtystep | Positive Int | Purchase Quantity Increment To buy more than the minimum purchase quantity, suggest an increase on a fixed scale Example: 6 | ||||||||||||||||||||||||||
| qtymax | Positive Int | Maximum Purchase Quantity 0 means unlimited or limit it by putting a multiple of the Increment N * qtystep Example: 36 | ||||||||||||||||||||||||||
| qtydisc | Varchar | Max 30 Quantity Discounts There are two types of discounts:
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 | ||||||||||||||||||||||||||
| unit | 32 Char | Product Unit You may add a unit Example: per kg when offering tomatoes | ||||||||||||||||||||||||||
| avail | 32 Char | Product Availability Inform your customers about the availability of a product by entering that information Example: within 3 days |
Swiss made eCommerce