Skip to main content

CSV price/stock import

Updated

ℹ️ You can synchronise your price and stock information by providing us with a CSV export. The export has to be publicly accessible via HTTP or HTTPS (recommended) and will be fetched every 5 minutes.

The stock of refurbed items that have an SKU assigned and are missing from your export are set to 0.
Offer SKUs in your export, that don't have a matching SKU in the refurbed offers will be ignored.
The CSV file must not be empty. The column headers need to stay in the file at any time.
Send the URL to integrations@refurbed.com


⚠️ Before you start: Be aware that your CSV export must always reflect correct stock. You need to make sure stock values are correctly deducted as new orders arrive.

Plan your integration, so that you can process orders as soon as possible or your CSV export's stock values are outdated and will reset the stock of happened orders within the next 5 min, until correctly reflected in the CSV export. This will lead to overselling items.

We always deduct stock of order items automatically. ⚠️

 

Structure of the csv file

  • Column delimiter needs to be ; (semicolon)
  • Escape charcater needs to be " (double quotes)
  • Text encoding needs to be UTF-8
  • Decimal mark for numeric values has to be . (dot)
  • Order of the columns does not matter, header must match exactly
header column type description
product_code string Unique code (SKU) that identifies the product variant from your shop
price_gross numeric Gross price of the product. Value must be greater than zero.
vat numeric VAT in %, Value must not be empty.
currency string Currency like EUR, GBP, not special characters like €
stock int Current stock of item. Value must be greater or equal to zero.
name (optional) string Name that identifies the product variant/instance. This column is entirely optional.

 

Example

product_code;price_gross;vat;currency;stock;name
1000G;269.99;19.00;EUR;21;"Fancy Phone Green"
1000B;499.00;19.00;EUR;20;"Fancy Phone Black"
BB123;6239.00;19.00;EUR;3;"Expensive ""Furniture"""
123xx;125.25;19.00;EUR;0;"Out-of-stock item"


⚠️ Make sure to have the same amount of delimiters (;) on each row!
Also the column headers must match the example exactly.

 

Related articles