Skip to main content
All GuidesSupport (opens in a new tab)Back to Stallee

Start here

  • Getting Started
  • Start a Market Business in Australia
  • Plans and Billing

Sell

  • Products
  • Collections
  • Import Products
  • Stock Levels and Locations
  • Online Sales
  • Discounts
  • Google Product Feed
  • Orders
  • Customers
  • Sales
  • Stockists
  • Wholesale
  • Consignment
  • Subscribers
  • Reviews
  • Payments
  • Choose Stripe or Square for Online Payments
  • Turn On Square Payments
  • Refunds and Disputes on Square Orders
  • Custom Order Balances on Square

Shop website

  • Storefront Analytics
  • Policies
  • Site Design
  • Site Pages
  • Journal
  • Website Address
  • Links and QR Signs
  • Markets
  • Messages

Settings

  • Settings
  • Team
  • Backups

Your account

  • Account and Security
  • Closing Your Business

Market organiser

  • Your Organiser Workspace
  • Organiser Plans and Organiser Pro
  • Market Organiser Team
  • Market Stallholders
  • Market Floorplans
  • Publish Market Floorplans

Stallee help

Import Products

Bring your products in from Shopify, Squarespace, Etsy or Square, or update prices and stock in bulk from a Stallee export.

The Import Products page brings products into Stallee from outside. Choose From a File if you already sell on Shopify, Squarespace or Etsy, or keep your products in a spreadsheet: you can import them from a file instead of typing them again, and you can change prices, stock, tags and status on many products at once by importing a Stallee export. Choose From Square to match or import the items in your Square account. Only an owner or admin can import. The examples follow Mara Quinn, who is moving Saltbush Ceramics over from Shopify and also sells at markets with Square.

What Comes Across

Each product brings its name, description, category, tags, price, product code and photos. The product code is the short code that identifies a product; other platforms call it a SKU. A product that comes in choices, such as sizes or colours, comes across with every choice, and each choice keeps its own price, product code and stock. Your product list shows these choices as variants. Stallee keeps up to three options, such as Size, Colour and Finish, on a product.

New products arrive as drafts, so customers do not see them until you publish them.

Photos are copied from the web addresses in your file, so they must be public. A photo that cannot be fetched does not stop the product from importing; it is listed in the results so you can add it yourself. Stock is set at your Online location, so you need exactly one Online location (see Stock Levels and Locations). Prices are in your shop's currency. An Etsy export in a different currency is refused.

Start from a Sample Spreadsheet

If you are not moving from another platform, fill in Stallee's own spreadsheet instead.

  1. Choose Import Products in the menu, then choose Download a sample spreadsheet. You get a file named stallee-products-sample.csv.
  2. Open it in a spreadsheet program such as Excel, Numbers or Google Sheets. The first row names the columns; leave it as it is. Choose What Each Column Means on the page to see what goes in each one.
  3. Replace the example rows with your own products, one row for each. Only Name and Price are needed; leave any other cell empty.
  4. Save the file as a CSV (in Google Sheets, choose File, Download, then Comma-separated values), then import it as described under Import the File below.
The Import from a File section with the Download a sample spreadsheet link and the What Each Column Means list open, describing the Name, Description, Price, Stock and Product code columns and those after them.

For a product that comes in choices, such as a bowl in Small and Large, use one row for each choice. Give every row the same Name, put what the customer chooses, such as Size, in Option name and the choice itself, such as Small, in Option value. Each row has its own price, stock and product code. The sample's Ocean Bowl rows show this.

Products from a spreadsheet always arrive as drafts. Open each one, add its photos if you left Photo links empty, and publish it when it is ready.

Export Your Products

Export from the platform you are leaving:

Shopify

  1. In Shopify, choose Products, then Export.
  2. Choose All products, then CSV for Excel, Numbers, or other spreadsheet programs.
  3. Choose Export products and save the file.

Squarespace

  1. In Squarespace, choose Commerce, then Inventory.
  2. Choose Export and save the file.

Etsy

  1. In Etsy, open Shop Manager, then Listings.
  2. Choose Download CSV and save the file.

Import the File

  1. Choose Import Products in the menu (or Import Products on the Products page), then make sure From a File is selected.
  2. Under Product file (CSV), choose your file. Stallee tells you which platform it came from and how many products it found.

If Stallee says it does not recognise the columns in the file, the file is not one of the exports above. Choose Download a sample spreadsheet in the message, copy your products into the sample's columns and import that instead.

The Import from a File section of Import Products with a Product file field showing saltbush-products.csv, and a line saying it is a Shopify file with 3 products.

A table shows every product with its number of choices, price, stock, number of photos and what it will become. The Problems column lists anything that needs your attention. A product with a problem in red is skipped; the others still import. Notes in black, such as a shortened description, do not stop a product.

The preview lists Speckled Mug, Ocean Bowl and Fern Planter as drafts, with Publish imported products unticked below the table.
  1. Tick Publish imported products if you want products that were live on the other platform to go live in Stallee. Leave it off to import everything as a draft, and publish them when you are ready. Products that were drafts or hidden stay drafts either way. The box is shown only when the file says some products were live. It starts unticked each time you choose a file, including when you replace a file you have already previewed. A Stallee spreadsheet's products always arrive as drafts.
  2. Choose Import with the number of products, such as Import 3 Products. Keep the page open while the progress line counts up.
The Free plan can publish 20 products. Products over that limit are not imported when you publish; import them as drafts instead, or see Plans and Billing.

Read the Results

When the import finishes, you see how many products were created, how many were already in your shop and how many failed. Importing the same file again is safe: a product whose product code is already in your shop is reported as already there and is not added twice. A product with no product code is matched by its name.

The results of an import: 3 created and 0 failed, with a note that one photo for Ocean Bowl could not be fetched, and a link back to products.

The failure count includes rows skipped in the preview. If any rows failed, choose Download Failed Rows to get the row numbers, product names where available and reasons. Fix the problems in your original file and import it again. Products that already came across are skipped.

Update Prices and Stock in Bulk

To change many products at once, start from a Stallee export. On the Backups page, download your CSV export and open products.csv in a spreadsheet. Change the prices, tags, collections, category, subcategory or status, and add a stock column for the counts you want. Then import the file as above.

Stallee matches each row to a product by the id column, then by the product code in the sku column. It changes only the price, wholesale price, tags, collections, category, subcategory, status and stock, and never a product's name or description. A column you remove leaves that field alone. If a row matches no product or has neither an ID nor a product code, it is counted as failed.

A backup import result with 1 product updated, 1 row failed and a Download Failed Rows button.

Import from Square

If you also sell at markets with Square, bring your Square items into Stallee so both shops share one set of products. Stallee keeps the main stock count: Square never changes it without you checking.

Square is part of the Pro plan, and you connect it first on the Payments page. Until then, the From Square tab explains this and links to Payments.
  1. Choose Import Products in the menu, then From Square.
  2. Under Square Locations to Share, pick a Stallee stock location for each Square location you want to share, then choose Save Locations. Leave the others on Do not share. If the list has no stock locations, add one first on Stock Levels and Locations.
The Square Locations to Share section with the Square location Studio set to the Fremantle studio stock location, and a Save Locations button.

Match Square Items to Your Products

Under Square Items, every option in your Square account is a row with its product code, price and the Stallee product it is matched to, or Not matched. Search by item name or product code, open Filters to show only matched or unmatched items, and choose a column heading to sort. The list shows 25 at a time; choose Load More Square Items to fetch more from Square.

  1. Under Match Items to a Stallee Product, choose a product in Stallee product to match or add to Square. Use Search Products to find it first. If you search again before an earlier search finishes, the picker keeps the results from your latest search.
  2. Choose Match to Selected Product on the Square item it belongs to. If an item is only in Square, choose Import as Market-Only to add it to Stallee as a product you sell in person. A Square item with several options, such as a mug in Small and Large, shows one row for each option; choose Import Item on any of them to bring in all its options as one product with a choice for each.
The Match Items to a Stallee Product section with a Stallee product chosen, a Search Products button and a Create Selected Product in Square button.
The list of Square items with a search box, a Filters button, and columns for item, product code, price, matched Stallee product and actions. Each unmatched item has Match to Selected Product and Import as Market-Only buttons.

Stallee copies the price into its catalogue once, when you import. After a Square variation is matched, retail price edits in Stallee sync to its base price in Square. A scheduled sale price is sent when the sale starts, and the retail price is sent again when it ends. If a count in Square later differs from Stallee's, Stallee lists it for you to check on the Payments page.

Market Prices in Square

If a product has a market price (see Products), Stallee uses it at your market Square locations: those you share with a stock location of the type Market or pop-up. When you choose Create Selected Product in Square, the new Square item charges the market price there and the retail price everywhere else. When you import an item that already has its own price at a market location in Square, Stallee keeps that price as the product's market price. Stallee price updates change only the variation's base price, so Square's market-location price stays as a location override. If the market price changes, update its location price in Square too.

Bring All Your Square Items Across at Once

If your products are already in Square, you can add them all to Stallee in one go instead of one at a time. An item with one option becomes a Stallee product with its Square name and price. An item with several options, such as a mug in Small and Large, becomes one product named Stoneware mug with a choice for each option, named like Stoneware mug — Small. Each choice keeps its own Square price, product code and stock. If you import only some of an item's options now, the rest are added to the same product when you import them later. In your product list the item shows once, with its number of choices, which the list calls variants. See Products for how they work.

  1. Share at least one Square location first, as above, if you want your Square stock counts to come across too.
  2. Under Import Many Items at Once, choose where the new products appear: At markets only keeps them off your website until you publish them, and Online and at markets lists them in your online shop straight away.
  3. Leave Use Square's stock counts as opening stock ticked to start each product with the stock Square has at each shared location.
  4. Choose the items. Tick the box beside each Square item you want, or tick Select all items on this page for the 25 shown. To choose every item not yet matched, on every page, choose Select All Items Not Yet Matched. A line under the buttons says how many items are selected across every page.
  5. Choose Import Selected Items, which shows the number of items, such as Import 4 Selected Items. Stallee shows its progress, then tells you how many products it added and anything it left out.
The Import Many Items at Once section. Imported products appear is set to At markets only, Use Square's stock counts as opening stock is ticked, and the Import Selected Items button counts the Square items chosen.

Items already matched to a Stallee product are left as they are, so it is safe to run an import again after adding more items in Square. Square items with a variable price are skipped: give them a fixed price in Square first. Square does not send photos or descriptions, so add those to each product before customers see it online.

To go the other way, pick a product that comes in choices in Stallee product to match or add to Square and choose Create Selected Product in Square. Stallee adds one Square item with a variation for each choice, and matches each choice to its variation. A single choice cannot be created on its own: choose its product instead.

PreviousCollectionsNextStock Levels and Locations
Made for independent retail.
TermsPrivacyAccessibilitySupport (opens in a new tab)
Dark mode