CSV upload guide
Upload your whole inventory as one CSV file on the Offers page (Import CSV). The easiest start: click Export CSV, edit that file and upload it again.
The file replaces your whole inventory. Offers that are not in the file are removed. To change only a few prices, export first, edit the export and upload the whole file. Do not upload an export made with filters on: everything outside the filter would be removed.
File format
- A CSV file (
.csv) with a header row. Comma or semicolon as separator, both work. - UTF-8, as Excel's "CSV UTF-8" saves it.
- One row per size. Column names are not case-sensitive, and
_,-and anything in brackets are ignored:EU_Size,eu-sizeandPrice (EUR)all work.
Example
A correct file looks like this:
| SKU | Size | Price | Quantity |
|---|---|---|---|
IF6490 | 36 2/3 | 80 | 3 |
1202A056-109 | 36 | 180 | 4 |
II7055-100 | 42 | 199 | 8 |
DM7866-200 | 42 | 450 | 2 |
DM7866-200 | 44.5 | 600 | 4 |
As raw CSV, the same file reads:
SKU,Size,Price,Quantity
IF6490,36 2/3,80,3
1202A056-109,36,180,4
II7055-100,42,199,8
DM7866-200,42,450,2
DM7866-200,44.5,600,4
Columns
| Column | Also accepted as | Required | What to fill in |
|---|---|---|---|
SKU | Style Code, Style Number, MPN, Manufacturer Part Number, Article Number, Product Code | Yes* | The manufacturer style code, e.g. DM7866-200. Case, spaces and punctuation do not matter (dm7866200 works), and one part of a combined code (CV3583-003/CK4344-001) is enough. |
WOOVIN ID | WoovinID | No | WVN-12345, shown on the product page when you are signed in as a store, and in the export. Always wins, so you can keep your own code in the SKU column. |
EAN | GTIN, Barcode, UPC, EAN13 | No | The barcode of the size. Used when the code is not recognised; it also sets the size, so the size column can stay empty. We do not have the barcode of every product, so always fill in the SKU or WOOVIN ID as well. |
Size | EU Size, EU, US Size, US | Yes** | Name the column EU Size for EU sizes or US Size for US sizes. A column named just Size takes both: a plain number is EU, US 9 is US. See sizes. |
Price | Selling Price | Yes | Your selling price in euros. See prices. |
Quantity | Qty, Stock, Inventory | Yes | A whole number, 0 or more. 0 keeps the offer as sold out. |
Shipping Days | Shipping Time | No | 2 or 7 business days. Empty or no column: your standard shipping time. 7 only for stores approved for 7 days; otherwise the row is skipped. |
* At least one of SKU, WOOVIN ID or EAN. ** Not needed when the EAN is filled in.
Other columns (such as a product name) are ignored.
Sizes
Write the size as it is on the product page. We read it in many ways, so you can usually keep the sizes from your own system. Comma or dot both work, and EU or US may go before or after the size.
| Size | How to write it | Examples |
|---|---|---|
| EU size | The EU size. A plain number is an EU size. | 42 42.5 42,5 EU 42 42 EU |
| Third (adidas) | The size with its third, or a decimal: .3 is 1/3, .7 is 2/3. | 42 2/3 42.7 42,7 EU 42 2/3 42 2/3 EU |
| Double size (slides) | Both sizes. | 41-42 41/42 EU 41-42 41-42 EU |
| US size | US before or after, or a US Size column with just the number. On a women's or kids' model, US 9 finds US 9 (W) or the US kids' size: no need to add it. | US 9 9 US US 9,5 9.5 US |
| Apparel | The letter size, written out or short, or the number for apparel sized in numbers (such as waist sizes). | M Medium XL Extra Large 30 |
| One size | Any common way of writing it. | One Size OS O/S |
A size that does not exist for that product is skipped with size not found, so you see it in the result.
Prices
- Euros, rounded to whole euros:
129,129,95(130),€ 129,129 EUR,50,-. - Thousands:
1299,1.299,1.299,00and1,299.00are all 1299. - Negative prices, ranges (
100-120) and text are skipped, never listed at a guessed price.
How the upload works
- One offer per product, size and shipping time. The same product, size and shipping time on two rows becomes one offer: the lowest price, with the quantities added up. A 2-day and a 7-day offer on the same size can be listed side by side.
- Existing offers are updated, new ones created, and offers not in the file removed.
- The export also has a Product column with the product name, so you can see what each row is. It is not used when you upload: we match on SKU, WOOVIN ID or EAN.
- Undo. Before an upload removes offers, we keep a copy of your offers as they were. Download it from the notification within 7 days and upload it again to undo the upload.
- The result appears in your notifications (the bell): how many offers are new, updated, unchanged, combined and removed, which rows were skipped and why, with examples, and the copy from before when offers were removed.
- Only products in the WOOVIN catalog can be listed. Missing a product? Mail us the style code.
Why a row is skipped
| Reason | What to do |
|---|---|
| code, price or quantity missing | Fill in a code (SKU, WOOVIN ID or EAN), a price and a quantity. |
| product not found | Check the style code, or use the WOOVIN ID from the product page. |
| size missing / size not found | Use a size from the product's size chart; check EU versus US. |
| price not readable | Use a number such as 129 or 129,95. |
| quantity not readable | Use a whole number, 0 or more. |
| shipping days must be 2 or 7 | Use 2 or 7, or leave it empty. |
| 7 business days not enabled for your store | Use 2, or ask us to enable 7 business days. |
| apparel is not enabled for your store | Ask us to enable apparel. |
Want your offers to update automatically? Connect an XML feed or use the API.