You must have an automated way of updating price and stock information already or plan to use it on refurbed. We provide updating price and stock via CSV Import or our API.
Steps
1) Navigate to https://merchant.refurbed.com → Shipping Profiles section and create at least one shipping profile that you want to use.
2) Create a CSV file with a semicolon (";") as separator and the following headers or copy the example file below the table and remove the example data. All headers must be existent in the file.
| header name | required | description | default value if unset | type |
|---|---|---|---|---|
| instance_id | ✅ | refurbed’s internal reference number, can be found in our product catalogue (download in the merchant backend) | numeric | |
| sku | ✅ | SKU that will be connected to the offer, it will be the reference if you e.g. want to to offer updates via API. MUST be unique | string | |
| reference_min_price | ❌ | Can be updated via API or in merchant backend or you set an initial value | null | string |
| reference_price | ❌ | Can be updated via API/CSV Export or in merchant backend or you set an initial value | 9999 | string |
| reference_currency_code | ❌ | Offer currency as ISO 4217 code. 3 letter abbreviation e.g. SEK, EUR, DKK | EUR | string |
| stock | ❌ | Can be updated via API/CSV Export or in merchant backend or you set an initial value | 0 | numeric |
| grading | ❌ | AA, A, B or C. Please refer to our Quality charta | A | string |
| warranty | ❌ | Allowed value is M12. M = Months | M12 | string |
| shipping_profile_id | ✅ | ShippingProfile ID can be found in the merchant backend > Shipping profiles section. The choosen id will be connected to the offer. |
numeric | |
| taxation | ❌ | Allowed values are MARGINAL or GROSS | GROSS | string |
| battery_condition | ❌ | Allowed values are OPTIMAL or NEW. Only create, no update! Seller/Category must have permission. | string | |
| name | ❌ | Product name, only for reference | string |
3) Download our product catalogue and open it with Excel or LibreOffice.
4) Find the exact product you want to offer in our product catalogue. If the product is not in our product catalogue, you can request it at listing@refurbed.com.
5) Copy the corresponding Instance ID from our product catalogue into the instance_id column of the CSV file you just created, add your sku, the grading (A, B or C), the warranty and if you offer marginal vat → MARGINAL in the same row under the corresponding header. If you do not set any value we will default to the values above. Rinse and repeat this process for all your offers.
6) Save the file. You can either use our Open Source tool to upload your offers yourself or send the CSV file to integrations@refurbed.com, please add your shop name or ID with which you are registered in our system.
⚠️ We are not able to check if the associations/mappings are correct. You are responsible for selling the product that you associated/mapped with since that is what users on refurbed will see.
The offers we create will not be immediately visible to customers if set with defaults (price: 9999 and stock: 0). Offer price and stock can be updated automatically via CSV Import or Seller API referring to your SKU later.
Example file: