Inventory Specification

Inventory files in Logicbroker are designed to provide quantity and cost updates for all products available to the retailers. Products are typically setup from the retailer side indicating which products are available to be updated, these are identified by the MerchantSKU. All feeds received will be matched using the SupplierSKU to update the inventory and cost data.

 Tip:

Not all retailers will have products setup prior to submitting the first inventory update and may require the supplier to create their own products providing the MerchantSKU and SupplierSKU link. Always check with your retailer partner to verify how products are to be setup.

 Note:

If your a supplier receiving orders, you can update item identifiers on the order using the inventory feed. For example, if you need to receive a UPC or other item identifier we can update the order with information matched by the SupplierSKU from the inventory feed. Contact us for more details.

The structure shown below in Field Descriptions follows Logicbroker's standard schema in 2 formats, CSV and EDI. The EDI segments are listed next to each field to indicate what field maps to the standard 846 EDI from the Logicbroker schema.

 

Details and Sample Files

 

EDI
Download EDI Specs and Samples

 

Click the link above to download the standard 846 specification and samples. All fields listed below reflect the model schema for the Logicbroker standard. For example the snippet below would match the EDI field name REF02 (IO) - Warehouse in the Field Descriptions below. The value in the parenthesis (IO) will represent the qualifier in the previous element; in this case its REF01.

REF*IO*WH1~

For EDI fields in a loop like items, will be identified by being separated with a ":" for example LIN:QTY02 (33) would be represented below. "LIN:" indicates the element is under the LIN loop. QTY02 identifies the element value and again "(33)" within the parenthesis represents the related qualifier of "33" present in QTY01

LIN*1*VN*3C-APORTBARL*UP*018232559661*MG*MFG-5481*ST*ST-2222*SZ*9*VE*BLUE~
PID*F*08***PRODUCT DESCRIPTION~
CTP*DI*DIS*113.30~
REF*ACC*DISC~
QTY*33*14*EA~

 For Suppliers:

To learn more about how to integrate getting inventory using the EDI format see this link.

 For Retailers:

To learn more about how to integrate sending inventory to your partners using the EDI format see this link.

CSV
Download CSV Samples

 

Click the link above to download the CSV samples. All fields shown in the table below represent a column in the inventory feed. Each row will contain a new item record, specified by the unique SupplierSKU provided. If there are multiple rows with a duplicate SupplierSKU provided, the latest value in the feed will update.

The snippet below shows an example of simple inventory feed, updating only quantity.

SupplierSKU,Quantity
3C-APORTBARL,14

 For Suppliers:

To learn more about how to integrate getting inventory using the CSV format see this link.

 For Retailers:

To learn more about how to integrate sending inventory to your partners using the CSV format see this link.

 Note:

Logicbroker has the ability to create custom specifications for any format and file type. Please contact us and attach any samples of your custom format and we can quickly and easily implement it.

Field Descriptions

EDI Field Logicbroker Field Description Requirement

LIN:LIN03 (VN)

SupplierSKU

SKU for the party that is receiving the purchase order.

Mandatory

N/A

MerchantSKU

SKU for the party sending the purchase order.

Conditional - Required if setting up products. Used for matching.

LIN:LIN05 (UP)

UPC

UPC Code.

Optional

LIN: LIN07 (MG)

ManufacturerSKU

SKU provided by the manufacturer of the product.

Optional

LIN:QTY02 (33)

Quantity

Total Quantity available for sale, this would be the total quantity across all warehouses.

Mandatory

LIN:CTP03 (DIS)

Cost

Cost sold from the supplier to the merchant. This is the value that will be on the purchase order.

Optional

N/A

MSRP

Manufacturer's Suggested Retail Price

Optional

N/A

RetailPrice

Price in which the item will be sold to the end customer

Optional

LIN:PID05 (08)

Description

Short Description of the product

Optional - Used only for Import

N/A

SupplierDescription

Description provided by the supplier.

Read Only - Used only for Export

N/A

MerchantDescription

Description provided by the merchant. This is typically done during product setup using the matching file.

Read Only - Used only for Export

LIN:LIN11 (SZ)

Size

Size attribute associated with product

Optional

LIN:LIN13 (VE)

Color

Color attribute associated with product

Optional

LIN:LIN09 (ST)

Style

Unique attribute to identify specific characteristic of the product

Optional

N/A

Weight

Total Weight per each Quantity

Optional

REF02 (IO)

Warehouse

Code/Identifier indicating location of the Quantity. Used only if only providing one warehouse for all quantity. If quantities for mulitple warehouses are required, then start with Warehouse2.

Optional

LIN:SCH01 (018)

NextAvailableQuantity

Quantity available given date in "NextAvailableDate"

Optional

LIN:SCH06 (018)

NextAvailableDate

Date when next record of inventory will be available

Optional

LIN:QTY03

UOM

Unit of measure for the item getting updated.

Optional

N/A

WarehouseQuantity

Total quantity available associated with the Warehouse field. Should match total quantity.

Optional

LIN:QTY:LS:REF02 (WS)

Warehouse2

Second Warehouse code/identifer where inventory is located.

Optional

LIN:QTY:LS:QTY02 (33)

Warehouse2Quantity

Quantity available at the second warehouse.

Optional

LIN:QTY:LS:REF02 (WS)

Warehouse3

Third Warehouse code/Identifier where inventory is located.

Optional

LIN:QTY:LS:QTY02 (33)

Warehouse3Quantity

Quantity available at the third warehouse.

Optional

LIN:QTY:LS:REF02 (WS)

Warehouse4

Fourth Warehouse code/Identifier where inventory is located.

Optional

LIN:QTY:LS:QTY02 (33)

Warehouse4Quantity

Quantity available at the fourth warehouse.

Optional

LIN:QTY:LS:REF02 (WS)

Warehouse5

Fifth Warehouse code/Identifier where inventory is located.

Optional

LIN:QTY:LS:QTY02 (33)

Warehouse5Quantity

Quantity available at the fifth warehouse.

Optional

LIN:REF02 (ACC)

Status

Status code of the product. Typically to indicate if a product is discontinued or not available. See retailer specifications for what codes are required.

Optional

N/A

LastUpdate

Date in which the latest inventory update was provided.

Read Only - Used only for Export

Was this article helpful?
0 out of 0 found this helpful

Comments

0 comments

Please sign in to leave a comment.

Didn't find what you were looking for?

Submit a request