Import products from Xero
Bring the items you sell in Xero into Stackem as products, matched by code, and update them from Xero later.
This page lists the items you sell in your connected Xero organisation, so you can bring them in as products. To open it, go to Administration > Integrations, Accounting tab, and click Import under Import products. You need the Accounting Manage permission. If Xero isn't connected, you're sent back to Integrations to connect it first.
The list
Only items marked as sold in Xero, with an item code, are listed. Each shows its Name (with the start of its description), Code (SKU), Price, Tax and Stock tracked, and a Status:
- Tax is GST free for Xero's tax-free sales types, otherwise GST.
- Stock tracked is ticked when Xero tracks the item's stock.
- Status is In Stackem when a product already has the item's code as its SKU, or New if not.
The list starts filtered to New items. Clear the Status filter to see all of them. You can search by name, code or description.
Importing
- Import on a row imports that item. On an item already in Stackem, the button says Update.
- Import selected imports the rows you've ticked.
- Import all new imports every item that isn't in Stackem yet. The button shows how many items that is.
Items are matched to products by code: the Xero item code is the product's SKU. Importing an item again updates its product instead of creating a duplicate.
What's brought across
- The item's name, description and sales price, as Xero has them.
- The tax rate: the workspace's GST free rate for tax-free items, otherwise its GST rate.
- For a new product, stock is tracked as a running total when Xero tracks the item's stock. An existing product's stock tracking isn't changed.
Reconnecting Xero
Reading items needs a permission Stackem only started asking Xero for recently. If your Xero connection is older, the page says Reconnect Xero to import products. Click Reconnect Xero, approve it in Xero, then come back to this page.
Refreshing
Items are fetched from Xero and kept for about ten minutes. Click Refresh from Xero to fetch them again straight away, for example after adding items in Xero.