Retyping Clover items into WooCommerce by hand is the slowest way to keep two catalogs honest. Build one clean clover inventory spreadsheet instead, and map every field before anything goes live. That means item IDs, SKUs, UPCs, variants, categories, modifiers, tax rates, stock counts, printer labels and locations.
Treat the file as a one-time snapshot. Export, back up, edit one thing at a time, test a small import, then load the rest. CloverWoo handles the ongoing sync afterward. The spreadsheet does not.
Table of Contents
- Export Your Clover Inventory Spreadsheet
- Bulk Edits Go Best One Change at a Time
- Import Back Without Creating Duplicates
- Selling on WooCommerce Too? Match Your SKUs
- Frequently Asked Questions
Export Your Clover Inventory Spreadsheet
Clover documents a spreadsheet route for inventory management. You download a template, fill it in, and upload it through the inventory or menu import screen. Clover also offers an export option for items you already have. Menu names and paths change from time to time, so follow the current steps in Clover's importing inventory documentation rather than any click path copied from a blog.
Here is what Clover documents about the file:
- It must be an .xls or .xlsx workbook.
- It must stay under 5 MB.
- It must keep its tabs and column names exactly as the template has them.
- The template has separate tabs for items, categories, modifier groups and printer labels.
Before you touch anything, save an untouched copy. Give it a dated name, such as clover-items-original.xlsx. If an import goes wrong, you can compare against it or roll back.
A spreadsheet is a snapshot. It shows stock as it stood at the moment of export. It does not change when the next sale rings up at the counter.
Bulk Edits Go Best One Change at a Time
Bulk editing Clover inventory is safe when you change one type of data per pass. Do prices first and save. Do SKUs next. Then names, categories and stock counts. When something looks wrong, you know which pass caused it.
Protect your barcodes
Excel strips leading zeroes from numbers. A UPC such as 012345678905 (an example only, not a Clover figure) can turn into 12345678905. Format the UPC and SKU columns as text before you paste or type anything.
Pro Tip: Set the column to text first, then paste. If you paste first and format after, the zeroes are already gone.
Other editors
Google Sheets or Numbers can work if you export back to .xlsx without touching tabs or headers. Clover only documents its own template, though. Test a small batch before you trust any other editor.
Restaurant and retail quirks
Restaurants should edit modifier groups and printer labels on their own tabs. After import, check that required modifiers and sold-out items still look right.
Retail shops should keep size and color variants as separate, clearly named rows. Recount stock after any return so the sheet matches the shelf.
Import Back Without Creating Duplicates
Follow this order every time:
- Build a test file with 5 to 10 items.
- Upload it and read Clover's validation step.
- Confirm only when the preview looks right.
- Check the items in Clover.
- Import the full file.
Here is the duplicate trap. A Clover-focused import guide warns that rows with no Clover ID can be created as new items. That means importing the same file twice may double your catalog. Treat this as a risk to test, and read Clover's documentation on how IDs are handled.
Common mistakes are easy to avoid once you know them:
- Duplicate item names
- Missing SKUs
- Renamed or reordered columns
- The wrong file format
- Price cells saved as text
- Edits spread across many columns at once
After the import, run a short checklist:
- Compare the item count with your backup.
- Spot-check ten prices.
- Scan two barcodes at the register.
- Open one modifier group.
Keep the backup until every check passes.
Selling on WooCommerce Too? Match Your SKUs
If you also sell online, the SKU is the key. CloverWoo uses it to link a WooCommerce product to its Clover item. Identical SKUs in both systems link cleanly. Stray spaces and lost leading zeroes break the match.
Before you link anything, decide which system owns each field. Walk through this list:
- Clover item ID and WooCommerce product ID
- SKU and UPC
- Variations
- Item name and price
- Category and tax rate
- Stock quantity
- Modifier groups and printer labels
- Location
Be clear about timing. CloverWoo syncs stock about every 5 minutes and products about hourly. It is not instant. A sale in one place can take a few minutes to show in the other.
Think of the spreadsheet as the one-time cleanup. The plugin then keeps products, stock, orders and customers aligned. For a restaurant, an online order can print in the Clover kitchen. Stock drops on the next stock sync, not the second the customer pays. It is one plugin for Clover payments plus product, stock, order and customer sync with WooCommerce, with free setup help after purchase.
If you only need to load a new catalog once, Clover's own template is enough. For the full walkthrough of ongoing sync, read the Clover WooCommerce inventory sync guide. Once your SKUs match, the clover inventory spreadsheet has done its job, and you can See the platform pricing to stop reconciling counts by hand.
Frequently Asked Questions
Where do I get the Clover inventory spreadsheet template?
Clover's help pages say to download the template from the inventory or menu import screen. Menu paths may change, so check Clover's current documentation. Use that template, not a copy from another site.
Can I edit the Clover file in Google Sheets or Numbers?
Yes, if you export back to .xlsx and leave the tabs and headers unchanged. Clover only documents its own template. Test a small batch first.
Why did Excel remove the first zero from my barcode?
Excel treats a barcode as a number, and numbers have no leading zeroes. Format the UPC and SKU columns as text before you enter data. Then paste your values.
Does importing the same file update items or duplicate them?
Test it before you rely on it. Rows without a Clover ID can be created as new items, which may double your catalog. Keep a backup and start with a small file.
Does Clover inventory sync with WooCommerce after an in-store sale?
Not from a spreadsheet. A file cannot see sales made after you exported it. The plugin syncs stock about every 5 minutes, not instantly, so allow a short delay.