Inventory Management

* This information does not apply to suppliers using the Private Shopify Inventory App with Olivela

Learn Logicbroker: Understanding Inventory - this module offers a detailed guide on how to manage your inventory.

• Requirements
• Processes
• Managing Items
• Troubleshooting

Loading and updating inventory is a key process for supplier so Olivela has up-to-date information on the status of products. Logicbroker provides tools to upload, update and manage inventory through our portal for all integration methods.

________________________________________________________________________________________________________________

Requirements

How often does Olivela need my inventory?

Olivela requires inventory updates daily. 

• Manual Inv + Web Portal - upload daily feeds into the portal using the attached template
• EDI - send an 846 daily through your AS2/sFTP/FTP connection
• API - send inventory daily through your API connection

What information does Olivela require?

If you are in the testing phase, your inventory upload/846 should include:

• Supplier SKU
  • Portal: Column A
  • EDI: LIN:LIN03 (VN)
• Quantity
  • Portal: Column E
  • EDI: LIN:QTY02 (33)
• Cost
  • Portal: Column F
  • EDI: LIN:CTP03 (DIS)
• Supplier Description
  • Portal: Column I
  • EDI: LIN:PID05 (08)
• Size * if applicable
  • Portal: Column K
  • EDI: LIN:LIN11 (SZ) 
• Color * if applicable
  • Portal: Column L
  • EDI: LIN:LIN13 (VE)
• Style * if applicable
  • Portal: Column M
  • EDI: LIN:LIN09 (ST)

* for portal suppliers, these fields are highlighted in green and yellow in the template

If you are in production processing live orders, you will upload/send:

• a one-time file with all fields mentioned above
• a daily feed with only Supplier SKU and Quantity

________________________________________________________________________________________________________________

Processes

How to upload/send inventory

Refer to your specific integration documentation in the Getting Started section of the Knowledge Base and look for the inventory step.

How to discontinue an item

________________________________________________________________________________________________________________

Managing Items

Bulk item updates

If you would like to change the quantity for multiple items, the best way to do this is through your integration's inventory process

• Manual Inv + Web Portal - upload a fresh file with updated quantities
• EDI - send a new 846 through your AS2/sFTP/FTP connection
• API - send updated inventory through your API connection

Once updated information is sent, confirm in the portal to make sure your feed was received. See How do I know if my upload worked? below.

Updating and managing items through the portal

If there are a few items you would like to update and you don't want to upload/send a full feed, you can make changes to individual items in the portal. To do so, in the portal navigate to Products > Inventory Search > from here the actions you can take are:

• New Item - add a new item (make sure you include all the fields listed in the Requirements section)
• Delete - remove an item (note our system saves uploads in the Events section of the Inventory Feeds tab but deleting an item will clear it from the feed we send Olivela)
• Edit - make changes to existing items through the following fields:
  • Quantity
  • Cost
  • Description
  • Size
  • Color
  • Style

*there are multiple fields you can edit but only the above fields are relevant to Olivela

________________________________________________________________________________________________________________

Troubleshooting

Do I have to use the Olivela Inventory Template?

* only applicable to suppliers manually uploading inventory to Logicbroker using Excel/CSV

Yes, this template is pre-mapped into our system and will ensure the quickest and most effective upload - using a different template will cause issues.

Why are leading zeroes being deleted from my feed?

* only applicable to suppliers manually uploading inventory to Logicbroker using Excel/CSV

If you have information with leading zeroes, excel will automatically remove them. To fix this, you can either:

1. change the column to Text format instead of General or Number Format. or - 
2. add an apostrophe to the begging of your input (ex. '00548663) - this will keep all your formatting in place

Why are my items showing up in scientific notation?

* only applicable to suppliers manually uploading inventory to Logicbroker using Excel/CSV

SKUs and UPCs are often reverted to scientific notation due to their long number sequence. To fix this, you can change the column that shows up in scientific notation to Text format instead of General or Number Format.

Do I need to have inventory in the portal before completing test cases?

Yes, all suppliers need to have inventory in stage portal before moving on to test cases because test cases are generated off the items you have set up in our system. Depending on your integration method, Logicbroker or Olivela will complete this step so you don't need to worry about uploading inventory. Suppliers with the following integrations will have to complete this step: 

• Manual Inv + Web Portal
• EDI
• API

Refer to your specific integration documentation in the Getting Started section of the Knowledge Base and look for the inventory step.

I sent my 846 but it is not showing up in stage portal?

* only applicable to EDI suppliers

Make sure you are using the correct stage/test AS2 Identifier: STAGELOGICBROKERAS2, confirm you have our EDI information set up correctly and that your EDI connection is working.

My integration method doesn't require me to upload inventory, how will Olivela get my inventory?

* only applicable to suppliers using the Private Shopify Inventory App (Portal + O Shopify and O Shopify + LB Connector)

If your integration does not involve manually uploading inventory into Logicbroker, you are most likely going to be using the Olivela Private Shopify Inventory App. Suppliers using this app will work directly with Olivela on setting it up. No inventory will pass through Logicbroker, so any questions regarding the app, reach out directly to Olivela.

Why is there an error in my inventory upload?

If you upload your inventory and see the error: Inventory Import Error under the Events log, click on View to download a full report on why your inventory failed. Troubleshoot/adjust your feed from the feedback in this report and reupload/resend a new file. 

How do I know if my upload worked?

Once you upload your inventory as a Supplier Feed, you should see it under Events. The Events log will show you the time stamp of your upload, the summary (should say: Inventory Imported) and the user (if it was a manual upload). To see a copy of the upload, click on View. If there was any errors in your upload, the Summary will say Inventory Import Error. Click on view to