If you do not have an integration setup in your backoffice, you can also import your products manually. Need help? Email us at email@example.com and we can import your file, as long as you provide us the data in the required format (see import template below).
To import the file manually, follow the steps below:
- Go to your backoffice
- Click on Imports/Exports
- Select a file from your computer from the “browse” button
- Click on the “Upload” button
- Validate & map the fields
Important notes for creating your import file:
- File type requirements: csv or xlsx
- File headers should be in English, like shown in the template
- All mandatory fields need to be added, otherwise it’s not possible to import (see below)
- See here the template with the mandatory fields
- See here the categories available for mapping
- Columns labeled "Mandatory" is information we need to create products. If product information is missing in any of the "Mandatory" fields, we can't proceed with the file
- Columns not Mandatory can be filled in later. Required means the information needs to be added in order to publish
- Do not add "notes" in the files, do not add html, do not add emojis or copyright symbols.
- Do not rename any of the tabs or change the names in other languages, all columns need to be in English as the original template file
- Do not merge cells
- Many cells have dropdowns with the valid values we require. All valid values can be seen in the "Data Options" tab in the template file
- Products are often sold in different sizes, colors, styles and other options.These options we call 'Variants'. Each product variant should have his own row.
- Any rows with the same Product ID will be considered options of the same product.
- The product title should be of the main product. Specify in the Option columns what the variant is.
- If a product has multiple images, add each URL link in the same cell, separated by comma (“,”), in the order you would like images to appear on your storefront
- Save the file as Excel or UTF-8
Required (mandatory) product information in the import file:
- Product ID: The product code, should be the same for the products with the same variants
- Product Title: The name of the product, which will be shown in your storefront
- Variants per product: Each row should be a unique variant. In the column headers you can specify what kind of variant it contains, for example: "Option:Size"
- Categories: Note: you can't add your own categories to Orderchamp. We offer a select amount of categories and subcategories. You can find the whole list of categories in your back office > Import & Export > "Available Categories".
- Images: Add the images URLs. Images URLs need to be able to be accessed directly, without any login and without an expiration date.
- Description: Provide a clear and attractive description of your product, containing a minimum of 25 characters
- Brand: The brand of the product;
- Case quantity: The minimum quantity of your product that should be purchased
- Price: The B2B/wholesale price. This is the price retailers will pay for your product to purchase. The wholesale price is excluding taxes and is formatted with a decimal period and no currency sign (i.e. 14.95)
- MSRP (Manufacturer Suggested Retail Price): The Recommended Retail Price. What the retailer should charge the customer for this product. The MSRP includes taxes and is formatted with a decimal period and no currency sign (i.e. 14.95).
- Inventory: Inventory or Stock level (Required if Inventory policy is set to "deny")
- Inventory policy: The options for your Inventory policy are "Continue" and "Deny". "Continue" means the product can still be ordered, even when the stock level is 0. If you only want to sell that product when it's in stock, the policy should be set to "Deny". When the stock level reaches 0, the product will be marked as sold out.
- SKU: The Stock Keeping Unit, which is a product code and unique per product variant
- Weight: Mention the weight of your product.
- Materials: Same for the materials, such as “cotton, concrete, wood, polyester”.
- Made in: Where does your product come from? Provide us with the country of origin with the two letter land code, such as “NL, TR, CN, IN, IT”.
- Values: If your product deserves an extra label, to search for example, you can assign a value. Only do this if it actually meets the requirements, for example " Handmade, Eco Friendly, Organic, Social Good etc.".
- Tax level: the VAT percentage that should be charged: High or Low. Food, books and non-alcoholic drinks are low tax level, all other categories are high. It differs per country what the exact percentages are.
- Dimensions: Provide us with the dimensions by adding a separate column for length, width, height, diameter (in cm) and/or volume (in liters).
Important! Importing a file will not keep your inventory synced automatically. If you update inventory data on another platform, you will need to perform another import containing the same products in order to update the data on Orderchamp's platform.
We strongly recommend to setup an integration from the many integrations Orderchamp has developed. You can check the integrations list and instructions here. With an integration, your stock will be updated in real time instead of relying on manual imports, therefore you do not risk retailers ordering products that might be already out of stock before you manually update your stock.