Uploading item information is a fundamental step when setting up your Warehouse Management System. Logiwa is able to download this information in three different ways:
- Downloading item information from an online store. Items sync once a day from online stores, so if you add a new item, you will see this reflected in Logiwa the following day. You can also manually sync the items if you need the item in Logiwa immediately.
- Importing an Excel file into Logiwa that contains all mandatory item information.
- Manually uploading items through Logiwa's interface, one at a time.
Capabilities
- Can add a standard case or pallet quantities for each SKU. This allows you to perform your operations using the standard case/pallet unit of measure for a more efficient warehouse.
- Can set up 'kit' items for any items that are made up of different components.
- Able to have multiple barcodes. If cases have different barcodes than the units, then you can define this in Logiwa and the system will be able to know whether you are scanning a case quantity or unit quantity.
- Can set up multiple listing channel IDs per SKU, so if you have one item listed in various ways in your online store, we can manage all of those different listing channel IDs and link them to the one SKU.
- Add expiration date and lot/batch number requirements
- Define item weights which can then be used to calculate the weight of your outbound orders.
Note, this step is not adding actual inventory quantities. It is simply getting your items set up into Logiwa so we have all of the necessary information. To learn more about adding inventory, please read the following articles:
Can I receive Inventory without Scanning?
How Do I Receive Inventory (Mobile Receipt)
Setting Up Items in Logiwa
Screen Path:WMS → Setup → Item
Creating New Items in Logiwa
There are two methods within Logiwa to upload item information. The first method is recommended if you are only uploading one or two new items. If you are uploading more than five new items, it is recommended that you use method two, which will allow you to upload all of your item information in one excel spreadsheet.
First Method: “New” Button
The first method is to click on the “New” button and fill in the fields manually.
Item Information
SKU* |
This is a mandatory field. Define a code for the item. If you have an online store and want Logiwa to link the SKUs, this should match the SKU name defined in that store. |
Description* |
This is a mandatory field. Define a description of the item. |
Client* |
This is a mandatory field. Define the client whom the item belongs to. |
Item Type* |
This is a mandatory field. Select a type for the item among Purchased, Produced, etc. |
Status |
Choose between Active and Inactive. |
UOM* |
This is a mandatory field. Define the smallest Unit of Measure of the item: Unit, Case. |
Item Group |
Select the group that the item belongs to. |
Brand |
Define the brand of the item. |
Weight |
Define the weight of the item. |
Size |
Define the size of the item. |
Origin |
Define the origin country of the item. This is mandatory if you plan to ship internationally. |
Sales Unit Price |
Define the Sales Unit Price of the item. |
Purchase Unit Price |
Define the Purchase Unit Price of the item. |
Other Information
Kit Item (Bundle) |
Toggle on if the item is a kit. Note, 'Item Type' should be defined as 'Kit' or 'Produced'. |
Notes |
Write down additional notes if necessary. |
FNSKU |
AMAZON FBA SKU |
Product Image |
Upload an image of the item. |
Client
Using the Client tab, more than 1 client for an item can be created.
Client Info
Client* |
This is a mandatory field. Define the client whom the item belongs to. |
Flash Receipt |
Toggle this field on when you want to receive or pick by scanning barcodes one by one. |
Vendor
Vendor Information
Vendor* |
This is a mandatory field. Select the vendor of the item. |
Drop Ship |
Define DropShip Vendor for the item. |
Package Type
You can only have up to two different package types per item. One of them will be the smallest unit of measure (typically unit or eaches), and the second should be the standard case or pallet quantity.
Packing Type Information
Package Type* |
This is a mandatory field. Choose a package type between Unit and Case etc. |
Description* |
This is a mandatory field. Write down a description of the package type. |
CU (CU) |
Stands for Consumer Unit. Toggle on if the package type is the smallest UOM. |
SKU Quantity* |
This is a mandatory field. Define how many consumer units the package type contains. For instance, if the case is a 6 pack, and the unit of measure is units, then this quantity would be 6. |
Weight |
Define the weight of the package. This can be used to calculate the shipping package weight. |
Other Information
Length |
Define the dimensions of the package. |
Width |
|
Height |
|
Active |
Select this field as Inactive, if you want the package type to be invisible on screens |
Barcode
You can add multiple barcodes per SKU, and you can tie the barcodes to specific package types. If the case barcode is different than the unit barcode, then you can set the package type on each barcode so the system knows whether you are scanning a case quantity or unit quantity.
Barcode Information
Barcode* |
This is a mandatory field. Define a barcode for the item. |
Client* |
This is a mandatory field. Define the client whom the item belongs to. |
Vendor |
Select the vendor of the item. |
Package Type |
Choose a package type between Unit and Case etc. |
Component
If the item is a kit, components of the kit and their amounts can be specified on the “Components” tab.
Component Information
Component Item* |
This is a mandatory field and the component SKU should already be set up in Logiwa in order to add it to a kit. |
CU Quantity* |
This is a mandatory field. |
Listing Channel ID
Logiwa can perform multiple channel Inventory Management. On the “Listing Channel ID” tab, you can see the stores which the item is linked to. This information is automatically pulled from the online store if the seller SKU (SKU name defined in the store) is the same as the Logiwa SKU. If the SKU has multiple item listings within one channel, you may need to add the listing information and Seller SKU manually.
Listing Channel ID Information
Channel Item Number* |
This is a mandatory field. It is the unique item number that is used by channel. For example, ASIN on Amazon. |
Channel* |
This is a mandatory field. Select the store which the item is related to. |
Item Main Category |
Assign the item to the main category. |
Store Name |
Define the name of the store. |
Item Description |
Write down a description of the item. |
Active |
If not active, the inventory of this listing will not be synced. |
Not Include in Order |
If active, even if the item exists within the order, it will not be saved on order detail. |
Other Info
Seller SKU* |
This is a mandatory field. Define the Seller SKU that is used within the store, this field is the same as Item Code. |
Inventory Amount |
If stated, this inventory will be sent to the store regardless of checking the actual inventory. |
Unit Price |
Define the unit price of the item. |
Second Method: Importing From Excel
The second method for uploading item information is to import items from an Excel spreadsheet using our template. To do so, go to the Item Setup page and click on Download Excel Template in the lower left-hand corner and fill the template out as seen below.
Fill out the necessary fields, marked in red, and any additional information you would like to include on the item.
Printing Labels
You can also print item labels for your existing items. To print a label, go to the item setup page and select the item you would like to print a label for. If you would like to print labels for more than one label, activate Multi-Select at the bottom of the page before selecting the items to print labels for.
Use the Item Label button to print item labels. Note, if you have a Mac computer, you will need to contact the support team or your onboarding consultant to add a specific item label option.
Define the number of labels you want to print.
Select the printer to use.
If you would like to print a pallet label, use the Print LP Label button to print LP labels.
Couldn’t Find What You Were Looking For?
Write to our support team: support@logiwa.com
Tags: Getting Started, Item, Print label, Barcode, SKU, Item Setup, Listing Channel IDs