Where is it going?
How to export from Square
- In your Square Dashboard, open Items & services (it may be called Items & menus or Items & inventory), then Items, then Item library.
- Clear any search or filter first: the export only includes the items you are viewing. Click Actions, then Export Library, and choose All items.
- Choose CSV, not Excel. Square suggests Excel, but this converter reads the CSV file.
- Upload the file as it was downloaded. Opening it in a spreadsheet and saving again can change SKUs and the order of rows.
What to know about Square files
- The Square export has no images, so no images move. Add pictures in the new store after import. Every converted file says so.
- Rows with the same Item Name next to each other become one product, and each row becomes a variation. Square writes no item number, so the converter looks for where a new item starts. In Square's export, columns such as Shipping Enabled and Pickup Enabled are filled only on the first row of each item. A later row with them filled starts a new product. So does a row with a different description, or a variation name the item already has.
- When two products end up with the same name, the converter names them so you can check them. If the file has none of those columns, or has them filled on every row (as after a fill-down in a spreadsheet), it groups by name only and tells you which products were joined from several rows.
- Option Name 1 and Option Value 1 become the product option. When an item has several variations but no option, or some option values are missing or repeated, the option is named "Variation" and each variation name is its value. Option Name 2 and higher are read the same way, but we have not seen a real export with them.
- Stock comes from the Current Quantity column of the first location in the file where the variation is switched on, and the note names the location used. A stock count with a fraction (items sold by weight) is rounded toward zero, and those variations are named. Stock at other locations, location prices and locations where an item is switched off are not carried over, and the converter counts them for you.
- A blank or "Variable" price has no price to carry over. Shopify rejects products without a price, so those items are left out of Shopify files and listed; WooCommerce imports them without a price.
- Online Sale Price is not described anywhere in Square's help. When it is lower than the Price, the file carries the sale price with the Price as the compare-at price, and every such variation is listed so you can change it. When it is not lower, the Price is kept and you are told.
- Square Online visibility "visible" publishes the product. "hidden", "unavailable", archived items and any unclear value become drafts, with a note, so nothing hidden is published by mistake. What "unavailable" showed shoppers is not documented by Square.
- Not carried over, and listed when present: modifier sets, taxes, units such as sold by weight, vendor details, stock alerts and the pickup, delivery and shipping switches. Digital, Service, Event and Donation items become products without shipping; the items inside a Bundle are not linked.
- The weight unit is taken from the column name, such as Weight (lb) or Weight (kg).
- Built from Square's help pages and the layout of real Square exports published on GitHub. Square publishes no sample export. It was not tested by importing into a live store.
Only products move. Customers, orders, reviews, gift card balances, blog posts, pages and URL redirects are not in a product export, so CatalogHop does not convert them.