In order to trade with this partner, you must be an active Logicbroker customer.
- Connection method: EDI > AS2
- Order types: Dropship
Contacts
- New Partner Setup - integrationsupport@overstock.com
- Natalie Chapman - nchapman@overstock.com
- Lee Burr - lburr@overstock.com
Notes
- Logicbroker has many live integrations with Overstock so no testing is required
- Invoices (810s) are not sent to Overstock, they pay based on the ASNs (856s) they receive
- The invoices we create in LB are for supplier reporting and accounting purposes, but these
are not sent to Overstock on the supplier's behalf - Overstock accepts acknowledgments for all orders
- In the inventory upload, Supplier SKU and Merchant SKU are swapped
- Orders remain in an "open" status in Supplier Oasis until they are shipped. Acknowledgments (855s) will not move orders to acknowledged in Supplier Oasis unless the 855 is a cancellation
Integration flow:
- The retailer sends orders (850s) to LB
- LB sends orders to the supplier through LB or to the supplier's system
- If auto-acknowledgment is on: LB will generate an acknowledgment (855)
and send it to the retailer (this will not acknowledge the orders in Overstock
unless the acknowledgment is a cancellation) - If auto-acknowledgment is not on: The supplier will acknowledge incoming orders that are in a ‘Ready to Acknowledge’ status
- The supplier ships or cancels orders in Logicbroker or in their external system
- LB pulls shipments/cancellations if the supplier is using an external system
- LB sends acceptances/cancellations (855) and shipments (856) to the retailer
- If auto-invoicing is on: LB will generate an invoice but will not send it to
Overstock – Overstock invoices based on the shipment (856) - If auto-invoicing is not on: the supplier may create an invoice but LB will not send it to
Overstock – Overstock invoices based on the shipment (856) - Orders show as ‘Complete’ in LB and in Supplier Oasis
Retailer document flow:
- Sends Orders
- Receives Acknowledgements
- Receives Shipments
- Receives Inventory
Callouts
- Invoices are not sent to Overstock - Overstock pays off the 856 (ASN)
Process
Inventory is sent to Overstock as an 846 file. Suppliers upload/send a Matching File and Standard Feed into Logicbroker.
Daily Feed: Supplier uploads a new Standard Feed feed daily into Logibroker reflecting updated quantities *if no quantities changed from the previous day, suppliers don't need to upload a new file
Adding an Item: If the supplier is adding a new item to their assortment, they will add it to their inventory feed and upload it into Logicbroker as a Matching File and also as a Standard Feed
Schedule: Logicbroker has 2 scheduled jobs to send inventory to Overstock
- Daily Full Feed: this feed is sent out once a day and is for every item in your assortment.
What is being sent? In the portal, go to Products > Inventory Feeds > Download Files > Standard Feed > download
When does this job run? In the portal, go to Settings > Scheduled Jobs > Search for the EDI Inventory Exporter Job that runs once a day and see the time there *note this is in UTC time - Hourly Delta File: if there are any inventory changes or new uploads made by the supplier, Logicbroker will send out an hourly file with only changed items
Required fields
CSV Field | Column | Description | Required |
Supplier SKU | A | Overstock's SKU | Yes |
Merchant SKU | B | Supplier's SKU | Yes |
UPC | C | Optional | |
Quantity | E | Yes | |
Warehouse | O | Must match what is in Supplier Oasis *to find warehouse name, in Supplier Oasis, go to Account Settings > Warehouse (note this is case-sensitive) | Yes |
Warehouse Quantity | S | Must match Quantity if there is only 1 warehouse | Yes |
Vendor Number | BE | Assigned to the supplier by Overstock |
Yes |
See our Onboard with Overstock Quick Start Guide for onboarding instructions.
Issues | How to troubleshoot or resolve |
Orders missing in Logicbroker |
Logicborker cannot pull orders in from Overstock - Overstock needs to resend these. Reach out to order_resend_requests@overstock.com to have orders resent and include the following information in your email:
* note that resending orders is the only time Overstock needs the SOFS-specific order number and ID. The SOFS order number is listed next to the retailer or Overstock order number in the orders section of Supplier Oasis, and you can find your SOFS supplier ID on the company tab under Account Settings on the left-hand menu in Supplier Oasis |
846 rejected |
Make sure you are complying with Overstock's inventory requirements and process Check the following possible incorrect fields in your inventory feed (in the portal, go to Products > Inventory Feeds > Download Files > Download the Standard Feed
|
FAQ’s
Why aren't my orders closing in Supplier Oasis?
Orders remain in an "open" status in Supplier Oasis until they are shipped. 855 acknowledgments will not move the orders to an "acknowledged" status in Supplier Oasis unless the 855 is a cancellation.
To close out orders in Supplier Oasis, ship or cancel orders using your external system (ShipStation, Netsuite, etc.) or from the portal.
How do I add the Overstock Release Order number in ShipStation as a custom field?
Submit a ticket to support@logicbroker requesting the Overstock Release Order number be added in ShipStation as a custom field and specify which custom field you would like this to be in. Our team will work on the request and will reach back out once the change has been made. *note that in ShipStation, the field will be the custom field, not the name of the field (ex. CustomField1, not Overstock Release Order Number)
How do I add the Overstock Release Order number to an Advanced Export report?
This is a common request for suppliers using QuickBooks
Submit a ticket to support@logicbroker requesting the Overstock Release Order number be added as a field to a report in the Advanced Export. Our team will work on the request and will reach back out once the change has been made.
Comments
Please sign in to leave a comment.