Sourcing catalog & tools for EC sellers

1. Start with sample data. For real work, use Manage data to export a backup and start with an empty workspace. Packaging and purchase orders are saved in this browser; product CSV is session data.
2. Packaging: add boxes, bags or other materials and their stock. Link each product SKU to the quantity of material used per unit. Import shipment CSV, review deductions and confirm. Give each split shipment a unique shipment ID.
3. Purchase orders: create a unique PO number with supplier, currency, due date and SKU lines, or import the template. Record each partial receipt, up to the remaining quantity. Receipts update PO quantities only.
4. Product CSV: upload a CSV, map columns, fix required-field and price errors, and export a Shopify draft-product CSV. Review it in Shopify before publishing. The tool does not connect to your store.

Use the supplied templates without changing their headers. Back up browser data before changing device or clearing storage.

1. Open a workspace and keep its recovery key private. Export a JSON backup regularly; a recovery key is needed to reopen the same saved workspace.
2. Choose the ledger currency, then create a purchase batch with SKU, quantity and unit cost. Enter freight and other landed costs. Allocate shared costs by quantity or value, and review per-unit cost.
3. Record sales against the correct batch, including sales revenue and applicable selling costs. Record returns against the relevant sale so that quantities and profit stay consistent.
4. Read realized profit separately from the value of unsold inventory. Review batch details and export records for reconciliation. Currency conversion uses the values you enter, not live exchange rates.

This is a management tool; figures are not a tax return or certified accounting report.

1. Try the sample workspace. For your own data, create a separate workspace, keep the recovery key private and export a JSON backup before major changes.
2. Import your master stock CSV/TSV. Select the SKU and quantity columns. Keep unique master SKUs; original extra columns are preserved. Excel files must first be saved as CSV.
3. Map each channel SKU to the exact master SKU. Import order files and choose the channel, order ID, SKU, quantity and line ID where available. Remove cancelled or returned orders beforehand; the system does not automatically filter order status.
4. Review new, duplicate and blocked rows. Resolve unknown SKUs, conflicts and stock shortages before confirming. Duplicate identity uses channel + order + line ID, or SKU when line ID is absent.
5. Confirm to deduct stock. You can undo an entire import, or enter a stock adjustment with a reason. Review the history after any correction.
6. Import a platform stock template, map columns and set a safety buffer. Exported availability is max(0, master stock − buffer). Unmatched platform rows remain unchanged and need manual review. Download the update file and difference list, then upload through the platform’s own process.

File-based workflow: no real-time store sync and no guarantee against overselling. UTF-8 / Shift_JIS CSV or TSV; up to 5,000 rows, 60 columns and 700 KB per file. Keep backups and review platform requirements before upload.