Import Product Files on a 100 Server

Upload product files provided to you by your Suppliers from Transit.

To begin, log on to your 100 server and click Setup Products Import Products.

Import from Vendor allows you to import an entire product file that is received from the vendor. The file must be in the required format. The product file template is attached at the bottom of this article and can also be found here.

1. Select the file type that you are going to import. It must either be Excel or Text.
2. Click Select Source File, this will allow you to browse for your file. Once you select your file it will show up in the yellow source file line.
3. Click Import Products
4. You will need to select the vendor from the dropdown. All of their information will fill in. Click Continue.
5. Click OK
   
6. Choose an update method and verify the update on the right.

If an item is discontinued, you can still sell it but a discontinued message will appear. If an item is inactive, you cannot sell it. If an item is deleted, then it will no longer be in the system. 

1. 1. Update (Add/Change/Discontinue): This will update products that match the file and discontinue the rest.
   2. Update (Add/Change Matching Only): This will only update those in the system that match in the file.
   3. Update (Add/Change/Inactive): This will update products that match the file and inactivate the rest.
   4. Replacement (Add/Change/Delete): This will replace all items in the system with the items on the file.
   5. Update all Matching to Discontinued: will discontinue all products in the file.
   6. Update all Matching to Inactive: will inactivate all products in the file.
   7. Delete all Matching Products: will delete all products in the file.
      
      

Update methods 5-7 are advanced options that allow you to get products out of the system. For these options your file just needs the first three data elements (up to product SKU).

7. Once you have chosen your update method, click the Update Brandwise Product Database button. You will be asked to enter the administrator password (ssi). Then click continue, and the products will now be imported.