Home > Sell Your Items For Free > Import Your Inventory File > Inventory File Information

How do I import items from an existing inventory file?


Here we will show you how to provide your inventory file in the required format, together with some advice on increasing the likelihood of your items being found when people look on search engines like Google and Yahoo!.

Although there are 20 fields within this guide, only some are required (highlighted in red). The rest are recommended but optional.

Some general points:

•    Remove all JavaScript coding if copying data from your website
•    Ensure that you spell check your data
•    Basic HTML code may be included in the description text
•    Do not exceed the maximum field lengths
•    Ensure the header row is present and is mapped as per the field names below
•    When saving your completed inventory file, ensure to ‘Save As’ either .CSV or .TXT
Import inventory file now
Click here to download the example .CSV file
View motoring inventory file guide
View property inventory file guide

 Field Name  Maximum Field Length  Required
Your Product Reference 30
Yes
This is your reference for the item, which could be the SKU, UPC or EAN number. We use this to uniquely identify each item, and display this on any order information that we send to you. This field should not include speech-marks or apostrophes but any other punctuation is accepted.


 Field Name  Maximum Field Length  Required
Category 45
Yes
This is the category in which you want your items to appear. You can either enter the category name or category reference.

E.G  “Digital Cameras” or “340”

To view all categories and reference codes please click here



 Field Name  Maximum Field Length  Required
Title 80
Yes
This should provide shoppers with enough information to understand what the item is.

Important points to note:
•    Ensure each item has a unique title
•    Include any part number or catalogue number that identifies the  item  
•    Use title case (e.g. “Apple Ipod Nano MP3 Player”, not “APPLE IPOD NANO MP3 PLAYER”)
•    Do not include your shop window name(unless you are the manufacturer), but do include any recognised brand/manufacturer names
•    Do not include the item price in this field

Accurate & detailed titles are vital if your items are to be found via search engines like Google, Yahoo! and Bing


 Field Name  Maximum Field Length  Required
Description 4000
Yes
The description should provide FULL details of the item and its features. This is your opportunity to really sell the  item 

Important points to note:
•    Your description must be contained within quotation marks (“description”)
•    Use sentence case only, e.g. “Women’s Black Neck Scarf”, not “WOMENS BLACK NECK SCARF”
•    Ensure that any size, colour, length & weight details are included
•    Do not include the item price within this field
•    Leave any HTML code in the data. Some can be included and will be reflected in how your item description appears on screen – specifically <li>, <br>, and <p>. All other code is automatically removed.

Accurate & detailed item descriptions are vital if your  items are to be found via search engines like Google, Yahoo! and Bing


 Field Name  Maximum Field Length  Required
Manufacturer 45
Optional
Please enter the manufacturer of the item.  Even if you have included this information in the item title or description you should still complete this field.


 Field Name  Maximum Field Length  Required
Model 45
Optional
Please enter the model or model number of the item.  Even if you have included this information in the item title or description, you should still complete this field.



 Field Name  Maximum Field Length  Required
RRPPRICE
8
Optional
Please enter the RRP Price for this item (including VAT) in pounds and pence, separated by a decimal.

E.G  “ 129.99” (Please do not enter a £ sign)

It is important to use this field wherever possible – people love to see they are saving money!


 Field Name  Maximum Field Length  Required
SalePrice
8
Yes
Please enter your sale price (including VAT).  If this price is not different to that of RRP Price (above) then the RRP price will be displayed. Your price must be entered in pounds and pence, separated by a decimal

If your price is different (i.e. lower) than the RRP Price the item price on adflyer will be shown as follows:
WAS            NOW
£129.99      £99.99 (Please do not enter a £ sign)



 Field Name  Maximum Field Length  Required
Quantity
8
Yes
Enter the quantity level into this field. This number will automatically reduce each time a quantity is sold.

E.G  “18”


 Field Name  Maximum Field Length  Required
Availability
1
Optional
This field determines whether the item is to be displayed.

Please enter one of the following:
Blank - Leave this field blank if the item is to be displayed
1 - Temporarily removed (hidden)

To permanently remove a item, remove the entire item line from your inventory file.



 Field Name  Maximum Field Length  Required
Main Image
250
Yes
Please enter the filename of the item's main image. (No dynamic links please)

You will need to include the full URL and extension. For example .jpeg or .gif.

E.G  http://www.adflyer.co.uk/Images/Adverts/adflyer-tbd3bdvsz.jpg

Remember, items without at least one main image will not be displayed in your shop window


 Field Name  Maximum Field Length  Required
Image 2-5 (separate fields)
250
Optional
We can accept four additional images per item  (No dynamic links please)

Each additional image needs to include the full URL and extension, for example .jpeg  or gif.



 Field Name  Maximum Field Length  Required
UKShipping
8
Yes
 MainlandEuropeShipping 8  Optional
 ROWShipping 8  Optional
Please enter the shipping charges for the item.

UKShipping = Shipping charge to United Kingdom Mainland
MainlandEuropeShipping = Shipping charge to Mainland Europe
ROWShipping = Shipping charges to the “Rest of the World”

Your shipping price must be entered in pounds and pence, separated by a decimal (Please do not enter a £ sign.)
E.G  “4.99”

If you only ship to the UK, please leave "MainlandEuropeShipping" and "ROWShipping blank"


 Field Name  Maximum Field Length  Required
Keywords
250
Optional
Please enter any relevant keywords about the item. We will use this field to help us find any related item attributes and traits.

E.G  “Camera, Pentax, P30,Black, 35Mm Film, SLR Camera, manual focus, timer, tripod, camera strap, lens cap, body cap”


Click here to download the example .CSV file

Import inventory file now
Got some questions? Please contact us