For teams that run on WooCommerce
WooCommerce supplier CSV import without cleanup
Suppliers send catalogues and price lists in their own columns, every week or month. The WooCommerce importer wants its own layout, so shops rename columns in a spreadsheet, match SKUs by hand, and find out after the import which products were doubled or skipped.
How it goes today
- Open the supplier file in a spreadsheet.
- Rename and move the columns to the importer layout.
- Match SKUs and remove the ones already in the shop.
- Import, then check which rows failed.
How it can go
Load each supplier file without fixing the columns first.
You send the supplier file as it comes; the columns are matched once per supplier. You get a proposal with the new products (name, description, photos, price, stock), the changed prices and stock, and the products the supplier no longer lists. After your yes the new products are added as drafts and the changes are made, and a log keeps what changed in each run.
Say this in ChatGPT, Claude or Copilot
Your chat gets connected to Hypamoon first, with this request filled in. You paste your WooCommerce key in the portal, never in the chat.
With Hypamoon, when I send a supplier file, match its columns to our WooCommerce products by SKU. Show me the new products, the changed prices and stock, and the SKUs the supplier no longer lists. After my yes, add the new products as drafts with their photos and make the changes. Keep a log of each run.
You create the WooCommerce key yourself under WooCommerce, Settings, Advanced, REST API. It stays yours.
More for teams on WooCommerce
- I want orders to show as shipped, with a tracking link for the customer.
- Many of my customer emails ask where their order is, and I look each one up.
- The low stock email comes too late for a supplier with a four week lead time.
- When new stock arrives I edit every product in WooCommerce by hand.
- I want one page per customer with every order, the total and their favourite products.
- I want to know my repeat purchase rate and my sales per country.
- Business customers ask me for a proper PDF invoice of every order.
- Every month I export the orders and clean up the file for my bookkeeper.
- Our B2B customers email PDF purchase orders and we retype each one.
- I want the sales of yesterday by email, without logging in.
- I want to raise the prices of a whole category without opening every product.
- I want to ask customers for a review a week after their order arrives.
- I want to set a date for a product to go offline or back in stock.
- Customers who first ordered as a guest don't see those orders in their account.
- A bot placed hundreds of fake orders overnight and I cleared them one by one.
- We run two WooCommerce shops and I update the stock in both after every sale.
- Our shopping feed keeps refusing products because the GTIN field is empty.
- Our regular customers order the same every week and I type it in again each time.
- I have to set the photo for each colour variation one by one.
- Before each class I build the attendee list from the orders and email everyone.
- I want to tell customers their local pickup order is ready to collect.
- I add up our sales per state in a spreadsheet to see where we are getting close to nexus.
- We have thousands of old coupon codes and no safe way to clear them.
- I need 300 unique single-use discount codes for an event.
- I copy each order to the supplier who ships it and wait for the tracking code.
- When I sell one product, the stock of the other product should go down too.
- Each quarter I split our WooCommerce sales per EU country and VAT rate for the OSS return.
- For each sale I have to look up what the lowest price was in the last 30 days.
- Every morning I compare the bank statement with the WooCommerce orders on hold.
- I keep a spreadsheet of what each business customer owes us.
- Each month I work out in a spreadsheet what each consignor sold and what we owe them.
- Each month I work out the commission per influencer code by hand.
- Every day I copy the options and names from each order onto a production sheet.
- I open every order and write down what to pick.
- When a backorder is delayed I email each waiting customer by hand.
- I message every cash on delivery customer to confirm before I ship.
- Our business customers want an e-invoice, so I retype each order in our accounting package.
- At the end of the year I make a donation statement for each donor from our WooCommerce orders.
- Our webhook was off for weeks before we noticed orders had stopped coming through.
- I track the open core charges in a spreadsheet and refund each one by hand.
- Everything for WooCommerce