For teams that run on Lightspeed eCom
Lightspeed eCom tiered prices
Lightspeed eCom has quantity discounts per product, and each can apply to one customer group, with a start and end date. Its help lists them among the settings the import tool does not take, so a price list for wholesale customers is entered product by product.
How it goes today
- Open a product and go to its quantity discounts.
- Add each tier with its quantity and price for the group.
- Repeat this for the next product and the next group.
- Change them one by one when the price list changes.
How it can go
Tiered prices per customer group, set from one spreadsheet.
You keep the tiers in one spreadsheet: SKU, customer group, quantity and price or percentage, with dates if they run for a season. The quantity discounts in Lightspeed eCom are set from it, and a new version of the sheet changes only the tiers that differ. You get a short report of what was added, changed or removed.
Say this in ChatGPT, Claude or Copilot
Your chat gets connected to Hypamoon first, with this request filled in. You paste your Lightspeed eCom key in the portal, never in the chat.
With Hypamoon, take the price list I upload with SKU, customer group, quantity and price or percentage, and set these as quantity discounts in Lightspeed eCom for the right product and group, with the start and end dates in the list. When I upload a new version, change only what differs and email me what was added, changed or removed.
You create the Lightspeed eCom key yourself in your back office under Settings, Store Settings, Developers, on the Advanced or Professional plan. It stays yours.
More for teams on Lightspeed eCom
- Each month I export the invoices and work out the VAT per country in a spreadsheet.
- Each morning I rebuild my supplier's stock file in a spreadsheet before I can import it.
- I filter on low stock and work out per supplier what to order.
- After each order I email the supplier which items to ship to which address.
- Each new business account I check by hand and add to the right customer group.
- Each week I export the orders to see what sold and what we earned on it.
- I add related products by hand, one product at a time.
- Customers fill in their email in the checkout and leave, and nobody follows up.
- Before each sale I change prices and old prices by hand, and again when it ends.
- Each return means a status, a credit invoice and a refund, one by one.
- I copy each tracking code from the carrier's site into the shipment.
- Each month I place the coffee subscriptions again as orders, one by one.
- After each order for a gift box I count down the stock of what is inside it.
- I copy the engraving text from each order onto a list for the workshop.
- Each afternoon I count up from the orders what we need to bake for tomorrow.
- Our own driver gets a list that I sort by postcode myself.
- Before I make the labels I go through the orders to see which ones have alcohol in them.
- The German and French texts run behind on our new products.
- I add each new product in our Dutch store and then again in the German and Belgian ones.
- A product we removed shows an error page until I add a redirect myself.
- I work out the price per litre for each variant myself and type it in.
- An order to the UK got stuck because there was no HS code.
- Whether we passed the EU threshold for sales to other EU countries, the accountant works out afterwards.
- Our business customers who pay on account, I chase per order.
- A price list for our business customers I make by hand in a spreadsheet.
- Loyalty points are not available here, so I keep a list of our regular customers.
- For each paid course or e-book I send the link myself and set the order to shipped.
- An order with half an address I only notice when the parcel comes back.
- On my phone I do not see that a big order or a question in the comment came in.
- Whether each withdrawal was refunded in time, I do not keep track of.
- With a sale I do not know whether the old price was really the lowest of the last 30 days.
- Our product feed misses the variants and specs, so I keep a separate file.
- Customers who order food every six weeks sometimes forget, and buy it elsewhere.
- Everything for Lightspeed eCom