Merge multiple exported files
Access the Merge Tool here: Inventory Merge Tool
What Does the Merge Tool Do?
The Merge Tool is designed to help you combine product and stock entry information from two separate sheets into one comprehensive file. Think of it as a smart assistant that takes your product catalog and stock entries and creates a single, organized view of your inventory.
Important Tip: Before using the tool, make sure your input files are exported from the app by LONG pressing on the Export button. This will ensure that the file is exported in the default template
Understanding Your Input Files
Products Sheet
Your first sheet contains basic product information, including:
- Essential details like SKU, Product Name, and Barcode
- Category and Unit of Measure information
- Quantity details (both book and counted)
- Product variations
- Custom information like Color, Brand, or Images (if you use them)
- Location information (starting with Default Location)
Stock Entries Sheet
Your second sheet tracks specific stock entries with:
- Basic identification (Row ID, SKU, Barcode)
- Product details
- Additional custom information specific to each entry
How the Merge Works
When you use the tool, it will:
- Take all your product information from the first sheet
- Find all related stock entries from the second sheet
- Combine the information into a single row per product
- Add any custom field information from stock entries as new columns at the end
If a product has multiple stock entries with different custom field values, the tool will combine them using a semicolon (;) as a separator.
What You’ll Get
The final output will be a single file that includes:
- All your original product information
- All location-specific details
- Combined custom field information from your stock entries
This gives you a complete view of each product and its associated stock entries in one place.