Import a discount list

When the items to discount are already in a list (a supplier's spreadsheet, a column in Excel, a few lines in an email) you don't have to find and tick them one by one. On Marketing → Discounts, click Import list… above the table.

Give Stokk the list

• Drop an Excel (.xlsx, .xls) or CSV file, or
• paste the list: a column copied from Excel, lines from an email, anything with item numbers or product names.

If the list needs explaining, add a note first, for example “the % column is the discount”. Stokk works out where the item numbers, discounts and dates are and tells you what it used. It then finds your products by item number, barcode (extra barcodes too) or the supplier's article number. A row with only a name is matched by name.

What the list can say

• A percent per item: “20%”, “-20%” or 0.2 all mean 20% off.
• A sale price per item. Stokk works out the percent from your current price, so the item ends up at that price.
• One percent for everything (“20% off all of these”). If the list gives no discount at all, type one at the top of the review.
• When the offer runs. The start and end dates are filled in for you.

Check every row

Each row shows what the list said, the product it matched, your price, the discount and the new price. You can change any discount, and only ticked rows are applied. Needs a look collects the rows that need you:

• Matched by name: tick the row if the product is right.
• Pick: the code is on more than one product (a shared barcode) or the name fits several. Choose the right one.
• Not found: click Find and search by item number or name, or leave the row out.
• Already on discount: a product has one discount at a time. End the current one first, then import again.
• Closed: the product is closed in your ERP and can't be discounted.
• Listed twice: only the first row counts.
• 70% off or more is flagged, so a typo doesn't slip through.

Apply

Set the start and end (a blank start means now), pick the channels and a campaign, and click Apply. Each item gets its own discount at its own rate, exactly as if you had applied it from the table, and it reaches DK and Shopify on the next hourly run. See Discounts for how the channels behave.

Without a campaign, the discounts are grouped under the file name (“From autumn-offer.xlsx”). The table switches to that group when you apply, and you can find it again later in the campaign chips above the table, to follow it or end it in one go.