Overview

Amazon Just Walk Out posts sales data to Yellow Dog’s webhook and Yellow Dog pulls sales into the customer database.

Sync Approach

This integration includes the following elements:

  • AJWO’s process to post sales data to Yellow Dog’s webhook

  • Yellow Dog’s AWS Event Bridge process and Showdog API to stage the sales data to the customer database’s S3 bucket

  • Yellow Dog’s AJWOConsole application to pull the staged sales data from S3 into the customer’s database, match to items, and adjust on hands

  • Yellow Dog’s Process Sales application to update sales report data

Sync Frequency

AJWO posts sales in real time and Yellow Dog’s AJWOConsole can be scheduled to run as frequently as every 15 minutes (depending on what else is running against the database); Process Sales normally runs once per day to update reports.

Configuration

This integration can support

  • Multiple AJWO stores (AJWO store = AJWO instance) against a single Yellow Dog database

    • Note that this configuration will require a separate sync application per AJWO store

  • Multiple AJWO stores mapped to the same Yellow Dog store (requires one sync application per AJWO store)

This integration does not support

  • Multiple Yellow Dog databases against a single AJWO instance

Requirements

Client

  • Confirm AJWO StoreId to Yellow Dog StoreID mapping(s)

  • Ensure that items in AJWO have corresponding items in Yellow Dog that will match on AJWO merchantSku to Yellow Dog ExternalID, Yellow Dog SKU, or Yellow Dog UPC

  • Confirm whether sales will match on ExternalID, SKU, and/or UPC in Yellow Dog

    • If using ExternalID, confirm whether location specific and/or global externalIds will be used

Yellow Dog

  • Configure and schedule AJWOConsole

    • Complete installation steps to generate the lookupKey for the webhook

  • Configure and schedule ProcessSalesConsole

POS

  • Provide Yellow Dog with

    • AJWO StoreIDs 

  • Add each AJWO StoreID to Event Bridge

Data Exchange

Sales Data from POS

AJWO posts sales in real time and Yellow Dog’s AJWOConsole can be scheduled to run as frequently as every 15 minutes (depending on what else is running against the database); Process Sales normally runs once per day to update reports.

Sales can be reprocessed in the Yellow Dog database and S3, but only sales created after the webhook/EventBridge setup has been completed will be sent to the webhook and available for processing/reprocessing.

Yellow Dog Stores are mapped to AJWO Locations.

Sales are matched on AJWO merchantSku to Yellow Dog ExternalID, SKU, or UPC.

We pull in the following sales data:

Modifiers are not supported in AJWO

Workflows - Where Preformed

Accounting Export:

Total Net Sales only (Retail*Quantity-Discounts)

Limitations: