Jonas Item Import

The Jonas Item Import simplifies data entry for your inventory by allowing you to upload a single CSV file to manage both item creation and merchandise receiving.

This tool is designed to save you time and effort by enabling bulk updates and entries for inventory management. It helps you create new items in your inventory, update existing items with new stock levels, manage vendor and location-specific details efficiently.

Go to Utilities → Import → Inventory → Jonas Item Import

Download the sample CSV file to see the required format. Open the sample file in a spreadsheet editor (e.g., Excel) and fill in the relevant details. Save your updated file in the same CSV format. Return to the Jonas Item Import page, upload your file, and click Import.

The CSV file is designed to handle essential item details and stock levels. The following fields will appear as columns in the file: 

• SKU: Universal Product Code for the item
• Item Name: Name of the item.
• Unit Retail: Retail price of the item.
• Vendor ID: Unique identifier for the vendor.
• Vendor Name: Name of the vendor.
• Units on Hand: Current stock quantity available.
• UPC code: UPC code of the item
• Category: Classification of the item (e.g., Apparel, Food).
• Unit Cost: Cost price of the item.
• Style Number: Identifier for the style of the item.
• Logo Attribute: Attribute indicating logo or branding.
• Vintage: Attribute indicating vintage.
• Gender: Gender category for the item.
• Color: Primary color of the item.
• Units on Order: Quantity Currently on Order

New Item Creation: If the item’s UPC Code is not already in the system, a new record will be created with all the provided details.

Inventory Updates: For existing items, the system will update stock levels based on the Units on Hand and Units on Order fields.

• If the SKU exists but other details differ, they will be updated unless protected by system settings.

Articles in this section

• Item Import Field Descriptions
• Overview
• Merchant Onboarding
• Navigation Bar
• Reports
• Items
• Settings
• Dashboard Overview
• Company
• Register

See more