Overstock

In order to trade with this partner, you must be an active Logicbroker customer.

Become a Logicbroker Customer

 

General information
  • Connection method: EDI > AS2
  • Order types: Dropship

Contacts

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
Documents

Retailer document flow:

  • Sends Orders
  • Receives Acknowledgements
  • Receives Shipments
  • Receives Inventory

Callouts

  • Invoices are not sent to Overstock - Overstock pays off the 856 (ASN)
Inventory

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

 

Onboard

See our Onboard with Overstock Quick Start Guide for onboarding instructions. 

Onboard with Overstock

Troubleshooting and FAQs
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:

  • Email Title: Resend Orders
  • Supplier Name
  • Requested Order Numbers
  • SOFS Supplier ID (If Available)
  • Preferred email address (If any questions occur or additional information is needed to resolve

* 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

  1. Invalid warehouse name - warehouses are defined in Supplier Oasis for each customer, have the customer send the “warehouse name” defined under Account settings > Warehouses (case sensitive)
  2. Missing required field in inventory 
    • Warehouse (case sensitive)
    • Vendor Number (assigned by Overstock)
  3. Incorrect Supplier/Merchant SKU - Supplier SKU should be in LIN01: Supplier SKU and Merchant SKU are swapped in the inventory template, make sure that in the inventory feed:
    • Supplier SKU - is Overstock's SKU
    • Merchant SKU - is the Supplier's SKU

 

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.

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