Uploading item information is a fundamental step when setting up your Warehouse Management System. Logiwa is able to download this information three different ways:

1. 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.
2. Importing an excel file into Logiwa that contains all mandatory item information.
3. Manually uploading items through Logiwa's interface, one at a time.

 

Capabilities 

• Can add 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 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)

How to Adjust Inventory

Setting Up Items in Logiwa

Screen Path: WMS > Setup > Item 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 “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 for 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 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 a main category.
Store Name	Define the name of the store.
Item Description	Write down a description of the item.
Active	If not active, 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 store, this field is the same as Item Code.
Inventory Amount	If stated, this inventory will be sent to 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 Item Label button to print item labels. Note, if you have a mac computer, you will need to contact 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 Empty 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