Using the inventory import feature in TWICE allows you to efficiently manage large amounts of data, making it ideal for adding new articles and SKUs or updating existing inventory specifications in bulk. This guide provides an overview of how to prepare and execute an inventory import, along with a downloadable CSV template to aid in the process.
How to Import Your Inventory
Access Inventory Tools: In your TWICE Admin, navigate to Inventory and click on Import in the toolbar of your Inventory Articles table.
Prepare and Select File: Click Choose file to select your prepared CSV file.
Review Import Details: Check that the import details are correct and click Confirm import.
Automatic Update: Your inventory will automatically update with the newly added or edited inventory articles, SKUs, and specifications from the import file.
Data Format and Requirements
File Formats: The inventory import function supports CSV or TXT file formats.
Preparation: The best way to ensure your file is in the correct format is to export your current inventory, make the necessary changes, and then import the updated file.
Learn how to open and edit .CSV files with a spreadsheet tool here.
Using the Provided .CSV Template for Inventory Import
To simplify your inventory import process, we've included a .CSV template file that you can download and use as a guideline:
Download the Template: Access and download the template file from the provided link on the bottom of this page.
Review and Understand the Format: Open the template in your preferred spreadsheet software to familiarize yourself with the layout and the types of information required.
Customize Your Data: Replace the example entries with your inventory data, following the format and guidelines provided in the template.
Save and Import: Once your data is correctly entered, save the file and follow the import process outlined above to update your TWICE inventory.
Important Formatting Rules
Header Row: The first row is a header row which should not be modified as it helps TWICE identify the columns.
Localization Row: The second row contains headers you will see in your uploaded inventory in TWICE. It includes predefined inventory columns and space for custom specifications.
ID Column: The "id" column includes the internal ID of an article. Leave this blank when adding new articles. Do not modify this column for existing entries.
Delimiter: Ensure your CSV file uses a semicolon (";") as a delimiter.
Finalizing the Import
Review Confirmation: Before finalizing, TWICE will display a confirmation view showing all updates and new entries. This step ensures that all data is correct before import.
Error Handling: If there are any issues with your data, TWICE will highlight these for correction.
By following these detailed steps, you can leverage the inventory import feature in TWICE to streamline the management of your inventory, ensuring that your records are accurate, up-to-date, and reflective of your current stock levels.