If you offer a large range of products, we recommend that you simply set up the automated offer import via CSV file. The requirement for this is that each offer is assigned a SKU, this can be done manually or by using the product import.
You can set up the automated offer import in the shop backend under Imports & Exports - Offers or import the offers manually. Please read the instructions on how to do this in detail. You can find them attached at the bottom of this article.
To update your offers automatically on a regular basis, you can specify a URL (webhook) in step 5 of the offer import, where the offer file is stored and will be updated by you on an ongoing basis (according to the import interval). See also: How can I make my files available for automatic import?
You can define the interval at which our system accesses the file and compares your offers. This can be performed daily, every 6 hours, hourly or every 15 minutes.
The file for the offer import must contain a column with the title sku (article number) for the identification of the offer.
Additionally the file has to include one or more of the following columns:
- stock (stock)
- active (status of the offer)
- price (selling price)
- delivery_period (delivery time in working days or weeks)
A more detailed description of the allowed values for each column can be found in the file at the end of this article, which contains the instructions as well as an example.
The column base_price has been used for food and cosmetics in the past and is now only used as a fallback solution. IInstead, please enter the content quantity directly on the product in order to have the base price automatically calculated and correctly displayed.
Important: All SKUs that exist in our system and are supposed to be offered for selling must be included in the offer import. Otherwise the stock for missing SKUs will automatically be set to 0.
As soon as you have set up the automated offer import, we will notify you by e-mail. You will receive the result for each import by e-mail. Please check regularly that the import is working properly.