Step 4: Upload or send inventory – Mattel

Note: You will need to upload/send a live inventory feed once you move to the production portal as feeds do not carry over from stage to production.

Review your partner's inventory specifications

Portal, API, Shopify Suppliers: Review RETAILER NAME's inventory requirements from the Document Standards page in the portal. REMOVE SHOPIFY IF THE RETAILER DOES NOT SUPPORT SHOPIFY
EDI Suppliers: Review your partner's 846 specifications from the EDI page.

Create your inventory file

Portal Suppliers: Download an CSV/XLSX template from the Inventory Feeds page > Upload Files > Download Template > Retailer-Specific Inventory
API, EDI Suppliers: Your development and EDI teams should work on mapping all API/EDI specs and getting the file ready to send from your system.
Shopify Suppliers: Make sure you have SKU and quantity available in Shopify for our system to pull it in. Note: Duplicate SKUs in Shopify will cause issues. Remove duplicate SKUs in Shopify or reach out to support@logicbroker.com if you are unable to and need a workaround. REMOVE IF THE RETAILER DOES NOT SUPPORT SHOPIFY

Upload or send your inventory file

Portal Suppliers: Upload your template file into the portal from the Inventory Feeds page > Upload Files > Supplier Feed. Note: Excel uploads are preferred since CSV may cause scientific notation errors
API, EDI Suppliers: Send the inventory file through your established connection. Ensure you are sending it to the correct environment (if you are testing, please send inventory to our stage environment).
Shopify Suppliers: Once you have established your connection, we will pull inventory automatically from Shopify to Logicbroker hourly at 30 minutes past the hour. Note: You can manually run this job from the Scheduled Tasks page > look for the Get Inventory from API job > Go Faster. This job should take less than 5 minutes to run. REMOVE IF THE RETAILER DOES NOT SUPPORT SHOPIFY

Confirm your inventory file was uploaded/sent successfully

In the portal, from the Inventory Feeds page, go to Events > look for the Inventory Imported event to ensure your file was uploaded successfully. Review any errors and reupload/resend if necessary.

Upload a matching file REMOVE IF IT IS NOT REQUIRED BY THE RETAILER

You will need to upload a Matching File into Logicbroker to match your SupplierSKU to RETAILER NAME's MerchantSKU. Matching files control what SKUs are sent to your partner.

Download an CSV/XLSX template from the Inventory Feeds page > Download Files > Matching File
Fill in SupplierSKU (Column A) and Merchant SKU (Column B) Note: Reach out to RETAILER NAME if you do not know the merchant/partner SKU
Upload your template file into the portal from the Inventory Feeds page > Upload Files > Matching File. Note: Excel uploads are preferred since CSV may cause scientific notation errors

RETAILER NAME will approve your inventory

RETAILER NAME will review and approve the inventory sent. They will reach out if there are any isses or if any changes need to be made.

RETAILER NAME will upload a matching file

RETAILER NAME will upload a matching file with the Supplier and Merchant SKU into Logicbroker. This file is used to control which SKUs are sent to RETAILER NAME.

Change language if the Supplier is responsible for the Matching file!