Manage Inventory

WizCommerce offers you three ways to manage inventory: automatic sync through your ERP integration, bulk updates using Import/Export for large-scale changes across multiple products, and the Product Management page for quick edits to individual products.

To Get There: Manage > Import/Export > Inventory

Table of Contents

Before You Begin

• Ensure you have Admin access before making any inventory changes.
• If you are performing Import/Export for the first time, read the Instructions page and review the Sample page in the exported Excel file before making any edits.
• Use Import/Export for bulk updates across multiple products. Use Product Management for quick edits to individual products.

A. Manage Inventory Using Import/Export

Import/Export lets you update inventory data in bulk — adjusting available quantities, backorder settings, stock thresholds, and on-order details for multiple products at once. This is useful when you need to make large-scale inventory updates without editing each product individually in the platform. 

Instead of making changes one by one, export your inventory data as an Excel file, make your edits, and import it back. The platform automatically updates all changed records.

Step 1: Export the File

1. Go to the Manage button in the left sidebar of WizOrder and click Import/Export.
2. Select Inventory from the available modules.
3. Click Export to download the inventory data file.
   
   

Step 2: Review the Exported File and Make Edits

1. Access the downloaded file through the notification bar.
2. Open the Excel file. You'll find three sheets: Instructions, Sample, and Data Sheet. If this is your first time using Import/Export, read the Instructions page and review the Sample page before making any changes. 
   
   
3. Go to the Inventory sheet and make your changes.
   
   
4. Here is what each column in the Inventory sheet represents:
   • Track Inventory?: Whether inventory is being tracked for this product (Yes/No)
   • Available: The current number of units available for ordering
   • Backorder Allowed: Whether buyers can place orders when stock runs out (Yes/No)
   • Backorder Limit: The maximum number of units that can be ordered on backorder
   • Out of Stock Threshold: The inventory level at which the product is flagged as out of stock
   • Notes: Any internal notes or additional information attached to the product
   • On Order Quantity: The number of units currently on order from the supplier but not yet received
   • On Order Date: The expected date the on-order units will be received
5. Make your changes. For example, update the Available quantity to 999 and reduce the Backorder Limit to 100 for the relevant products. Apply the same approach to update any other column as needed.
   
   
6. Save the Excel file once you've finished making all changes.  
   

Step 3: Import the Updated File

1. Go back to Import/Export in WizOrder.
   
   
2. Select Inventory, then click Import. 
   
   
3. Upload only the Inventory sheet — out of all Excel pages, only this sheet needs to be imported.
4. Follow the walkthrough video to complete the import.
   
   
5. Check the import progress in the notification bar by clicking the bell icon. 
   
   
6. Confirm the changes by checking the inventory status of the updated products. For example, the available quantity for SKU ID Acrylic-002 should now reflect the updated value of 999.
   
   

Mandatory Columns for Inventory Import

Always include these columns in your file — do not delete them:

• System ID (do not delete)
• Grouping Identifier (ignore if no variants)
• Reference ID
• SKU ID
• Name

B. Manage Inventory Using Product Management

Use the Product Management page in the WizOrder web portal to update inventory details for individual products. 

Step 1: Locate the Product

1. Go to the Product Management tab.
2. Find the product you want to update using the search bar or filters.
   
   

Step 2: Edit Inventory Details

1. Click the product to open its product management page.
   
   
2. Select the Inventory tab from the top navigation.
   
   
3. Click Edit.
   
   
4. Update the relevant fields as needed. For example, update the available quantity to 999 and reduce the backorder limit to 100.
   
   
5. Click Save.