For teams that run on Lightspeed eCom
Lightspeed eCom supplier feed
Many suppliers send their stock and prices as a file or a link. Lightspeed eCom updates products through its import tool, with its own column titles and up to 25 imports a day. So the supplier's file is first rebuilt in a spreadsheet to match.
How it goes today
- Download the stock and price list from the supplier.
- Rename the columns to the titles the import tool expects.
- Match the supplier codes to your own SKU or EAN by hand.
- Import the sheet and check which rows did not match.
How it can go
Stock and cost prices from your supplier's file, updated each day.
Each day the supplier's file is read from the link or the email it comes in, matched to your variants on SKU, EAN or article code, and the stock and cost price are updated in Lightspeed eCom. You set the rules once, such as a stock buffer or a margin for the sale price. Rows that do not match land on a short list for you. This is for stores that keep their products in eCom itself, not in the Lightspeed till.
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, each morning, read the stock and price list my supplier sends and match each row to my Lightspeed eCom variants on SKU, EAN or article code. Update the stock and the cost price, keep a buffer of two, and set the sale price from the margin I give. Email me a short list of rows that did not match and of products that went out of stock.
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.
- 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.
- I enter quantity discounts product by product for each wholesale 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