| 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
| -1 | means delete | | 0 | means blocked | | 1 | means standard | | 2 | means special offer | | 3 | means new | | 4 | means reserved | | 5 | means rental | | 6 | means contact | | 7 | means bargain |
Example: 1 |
| 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
| 0 | means out of stock | | 0 < # | means this many are in stock | | # < 0 | means 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
| Stockt | equals | = | i.e. new stock = 15 | | Stockt | equals | + | i.e. new stock = 50 = 35 + 15 | | Stockt | equals | - | i.e. new stock = 20 = 35 - 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
| Blank | means the product is not added | | 0 | means the product is added and alphabetically sorted | | 0 < # | means product is added at position # |
Example: 3 |
| 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:
| 0 | means standard product, the age is not asked | | 1 | means alcohol | | 2 | means spirit | | 3 | means tobacco |
Example: 1 |
| 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:
| 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 |
| dgn | Positive Int | Dispatch Group Number
The Dispatch Group Number allows all products with the same Dispatch Group Number to be handled by the same Dispatch Group
Example: 4 |
| pes | [1, 11] & Blank | Product Element Sort
Organise how elements show on the product page:
| Blank | means sort according to global setting specified in [TOOLS] -> [Shop Behaviour] | | 1,2,3,4,5,6,7,8,9,10,11 | means 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 |
| 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
| 0 | means product has no licence | | 1 | means product has a licence and the licence is bound to the product's ida | | 2 | means 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] 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:| :+# | 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) |
| 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| 0 | means nothing is bold | | 1 | means 1st row is bold | | 2 | means 1st column is bold | | 3 | means both, 1st row, and 1st column are bold |
Example: 2 |
| videotit | 64 Char | Video Title
Example: Video : Pacha the Doberman |
| video | 1024 Char | YouTube video
Example: HnSgBXoU12c |
| videoa | [0, 1] Int | Video Automatic Start| 0 | means video does not start playing automatically | | 1 | means video starts playing automatically |
Example: 0 |
| renttit | 64 Char | Rental Product Title
Example: Rent a chainsaw |
| renthas | [0, 29] Int | Rental Product Has
This is the sum of a combination of:
| 0 | == | Google Place Autocomplete and Drive Duration Calculation is not active | | 1 | == | Google Place Autocomplete is active | | 2 | == | Product has default Google Place Autocomplete configuration | | 4 | == | Product has a predefined pick-up address | | 8 | == | Product has a predefined drop-off address | | 16 | == | Let Google calculate drive duration, drive distance, and draw polyline on Google maps |
Example: 3 == 1 + 2 which means Google Place Autocomplete is active and product has default Google Place Autocomplete configuration
Example: 21 == 1 + 4 + 16 which means Google Place Autocomplete is active, the product has a predefined pick-up address, and Google calculates drive duration, drive distance, and draws a polyline on Google maps |
| rentfa | 100 Char | Rental Pick-up Address
Note: If defined, 4 must be part of the renthas attribute sum and the attributes rentflt and rentflg must also be defined
Example: Piccadilly Circus |
| rentta | 100 Char | Rental Drop-off Address
Note: If defined, 8 must be part of the renthas attribute sum and the attributes renttlt and renttlg must also be defined
Example: London Heathrow Airport (LHR) |
| rentflt | [-90, 90] 7 decimals | Rental Pick-up Latitude
Note 1: If defined, 4 must be part of the renthas attribute sum and the attributes rentfa and rentflg must also be defined
Note 2: If undefined, leave it blank
Example: 51.5099401 |
| rentflg | [-180, 180] 7 decimals | Rental Pick-up Longitude
Note 1: If defined, 4 must be part of the renthas attribute sum and the attributes rentfa and rentflt must also be defined
Note 2: If undefined, leave it blank
Example: -0.1339960 |
| renttlt | [-90, 90] 7 decimals | Rental Drop-off Latitude
Note 1: If defined, 8 must be part of the renthas attribute sum and the attributes rentta and renttlg must also be defined
Note 2: If undefined, leave it blank
Example: 51.4679902 |
| renttlg | [-180, 180] 7 decimals | Rental Drop-off Longitude
Note 1: If defined, 8 must be part of the renthas attribute sum and the attributes rentta and renttlt must also be defined
Note 2: If undefined, leave it blank
Example: -0.4550471 |
| rentcit | [0, 48 * 86400] Int | Rental Check in Period
This is the period of time you need to prepare the rental product to have it ready for PICK-UP. This period of time is included in the rental price, but it is not added to the rental duration, maximum 48 days expressed in seconds
Example: 3600 which is one hour |
| rentcot | [0, 48 * 86400] Int | Rental Check out Period
This is the period of time you need to check the condition of the rental product after DROP-OFF. This period of time is included in the rental price, but it is not added to the rental duration, maximum 48 days expressed in seconds
Example: 5400 which is one hour and 30 minutes |
| 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
| 0 | means no package cost | | 0 < # | means package must be paid for each product | | # < 0 | means pay package only once even for several products |
Example: -17.50 |
| gwrap | [0, 1] Int | Product Gift Wrap| 0 | means product cannot be gift-wrapped | | 1 | means product can be gift-wrapped |
Example: 1 |
| gwrapcost | ± [0.00, 9'999.99] | Product Gift Wrap Cost| 0 | means gift wrap is free | | 0 < # | means gift wrap must be paid for each product | | # < 0 | means pay gift wrap only once even for several products |
Example: -7.80 |
| gnote | [0, 1] Int | Product Gift Note
| 0 | means product cannot have a gift note | | 1 | means product can have a gift note |
Example: 1 |
| gnotecost | ± [0.00, 9'999.99] | Product Gift Note Cost| 0 | means gift note is free | | 0 < # | means gift note must be paid for each product | | # < 0 | means pay gift note only once even for several products |
Example: 5.50 |
| deliserv | Varchar | Delivery Service| Blank means | the 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] Int | Box Quantity| 0 | means box quantity does not apply to this product | | 1 | means this product can form a multiple together with other products in the same box |
Example: 1 |
| 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:
| % | 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 |
| 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 |
or click here
