📥 Import your data
Import from Excel
Many shops use the import as chance to clean up their data. Circle-Hand works best with high quality data input - that's why most stores only import in-stock items.
September 29, 2026
You can use these templates or map the columns during the upload.
Go to settings > Data Import > Upload your files
It’s best to try with 5-10 items first before importing everything at once.
If your barcodes include letters, e.g. 28BL2921
Add the barcode with letters in the SKU column.
Go to Circle-Hand Settings > Square / Shopify
Select “Send SKUs as Barcodes (for imported items only)”.
Click on “Push to Square / Shopify”
This will send the SKU into the barcode field in Square/Shopify, so you can scan items at checkout. One note: if you edit the item in Circle-Hand later, for example change the price, Circle-Hand will overwrite the barcode in Square with the barcode stored in Circle-Hand.
Best practice is usually to use numeric barcodes only. This makes syncing with other marketplaces and online shops easier. If only a few items have letters in the SKU, it may be easier to relabel those items so all inventory uses numeric barcodes.
Field with * are mandatory
*Client Number: Unique identifier for each client, must be a number
*Email: Client's email address, must be in standard email format
First Name/Last Name: Client's full name
Phone: Client's contact number. Example: +4917829400
Street/City/Zip: Client's full address
Notes: Any additional information about the client
Payout Preference: One of: {Bank Transfer, PayPal, Cash, Twint, Venmo, Voucher, Store credit}
Payment details: Details for the chosen payment method (e.g., bank account number, PayPal email)
Client since: Date client relationship began. Date format: DD-MM-YYYY}
Field with * are mandatory
*Barcode: Unique identifier for each item (numeric). Example {100}
*Client ID: Matches with Client Number from client CSV
*Title: Item name or description
*Selling Price: Selling price of item without currency symbol, e.g. {29.50}
*Direct Purchase: Whether item is ‘Direct Purchase’ or ‘Consignment’
Purchase Price: Only applicable for direct purchases
Consignment Share for Client: Percentage share for client {0-100}
Description: Detailed item description.
Hand-In Date: {27/04/2024}
Expiration Date: When item should be returned/donated if unsold. Example {27/04/2024}
Remaining Policy: What to do with unsold items. One of {Return, Donate, Discard}
Sold Online/Sold in Store: Where item is sold ‘Online’ or 'Store’
Condition: One of {New with Tags, New without Tags, Very Good, Good, Acceptable}
Gender: {Male, Female, Unisex}
Season: {Spring, Summer, Fall, Winter}
Category/Brand/Color/Size/Material: Item specifications
Any other questions? Write us: max@circle-hand.com
