Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Overview

Excerpt
Komet Sales allows you to use an Excel file with a certain structure in order to make adjustments on your hard goods master product list and hard goods inventory, including adding new products, overwriting existing quantities, editing selling prices and costs. Through this option, you will be able to update hard good items available in the Setup>>Products>>Hard Goods and Inventory>>Pricing>>Hard Goods Inventory screens.

...

Info
titleUpload Limit

There's a limit on the number of rows and hard goods per line an be uploaded into the system at once:

  • The maximum quantity per line is 999.
  • The maximum number of  rows per file is 5000 boxes.

...

sizesmall
Ui step

Go to Setup>>Data Import.

Ui step

The Data Import screen will open. 

Ui step

In the drop-down menu, select Hard Goods-Inventory & Product List.

...

The first step is to download the Excel file with your hard goods products. Notice that the system also gives you the option of downloading an empty template to create Hard Goods from scratch.

If you want to only update information in your master product list, proceed to step 5 (updated you Excel file and upload it into the system).

...

The Update Inventory option will affect hard goods records available in the Hard Goods Inventory screen. The system may add new products and/or overwrite existing selling prices and costs for the products identified in the Excel file you are uploading. For this process, the system will consider the internal product Id, meaning that all products available in the inventory will be updated, even if the hard good product description has been changed from the hard goods setup screen.

Ui step

Make the necessary changes to your hard goods within the Excel file downloaded.

...

An email notification will be sent with the results of the importing process. If the process is successful, an email will be sent to the logged user. If some register cannot be uploaded, the system will email a link with the discrepancy details and the reasons for the importation interruption.

...

Once the information is uploaded, we recommend you to validate if the information has been correctly imported into the Setup>>Products>>Hard Goods and Inventory>>Pricing>>Hard Goods Inventory screens.

Update Hard Goods Inventory - Multilocation Companies

The process for updating hard goods inventory in multilocation companies is the same. The only difference is that when selecting the Update Inventory option (step 5), the system will give you the option of selecting the locations for which the existing inventory should be updated. You can select All for updating prices and costs of available inventory in all the locations at once.

Image Removed

Panel
titleRelated Articles

Filter by label (Content by label)
showLabelsfalse
max10
showSpacefalse
sorttitle
cqllabel in ( "data-import" , "standalone" , "standalone-po" , "upload-po" , "hardgoods" , "pricing-hardgoods" )

Ui text box
sizemedium

(lightbulb)Roles enabled to perform this action: Admin.