1. Create the Inventory File and Configure Settings
Start by creating an inventory file. Review the optional settings — such as Purchase Orders, Units of Measure, Assemblies etc. — and configure them according to your business needs.
2. Connect Your Stores
Connect your stores (e.g., Shopify, Amazon, eBay) to the inventory file to track sales and inventory.
Note: If you track inventory in QuickBooks, export all settlements before your cutoff date before connecting your stores. You can always return to this step later.
3. Set Up Warehouses
If you want to track inventory by warehouse Add warehouses to your file:
Local Warehouse: Your primary Inventory location.
For Amazon: FBA Warehouses, Create one for each Amazon FBA store.
For Amazon: In-Transit Warehouse: For in transit inventory; set the warehouse type as “In Transit.”
If you have multiple local warehouses, we recommend to only creating one Master Local Warehouse for better inventory management.
4. Add Inventory Items
Add Inventory items - Establish a clear naming strategy to ensure consistency and simplify data entry, so that new purchases/bills can be entered easily by that same name
For larger item lists, use Excel for bulk uploads.
Add relevant details, such as Units of Measure or Assemblies, if applicable.
5. Add Default Costs
Add a default cost to each item. This step is critical before performing inventory adjustments and can also be completed in bulk using Excel for efficiency.
6. Map Listings
Map the SKUs to the corresponding inventory items. You can use the Unmapped shortcut (this might take some time to display) or upload an Excel file for faster mapping.
7. Set Start Dates for Stores
After mapping your items, you can set a start date for each connected store. From this date, inventory deductions will begin automatically.
8. Adjust Inventory
Perform initial inventory adjustments to align stock levels with the inventory as of the start date.
Local/3PL Warehouses: Typically requires a manual stock count. Use Excel for bulk adjustments.
FBA Warehouses: Use the FBA Adjustment feature. Make multiple adjustments during the first 30 days to account for in-transit shipments as of the start date.
9. Review and Configure FBA Shipments
Go to the FBA Shipments page to review and make necessary transfers, ensuring accuracy in tracking open shipments.
10. Add Bills or Purchase Orders and Review Landed Costs
Now you can start adding bills or purchase orders received after the start date, and review the Landed Cost feature to include additional costs like shipping, taxes, or fees in the inventory valuation.
11. Review Inventory Reports
Check the following reports to monitor inventory health and performance:
By following these steps, you’ll have a well-organized inventory system that supports efficient operations and accurate reporting.
.