Synchronization

Objective

  • For better monitoring between Seller Center and the Shops system, some additional tools are needed to see if there are issues for stock, price, or order statuses between the systems.
  • There are different views available for monitoring which products are currently updated to the Shop system. Also, a comparison between the stock-values is available, as well as a price comparison.
    • These two checks are important because it can occur that people change stocks or prices on the Shop system; however, this is not recommended.
    • Seller Center is the master of all product content; therefore, all content changes should be done via Seller Center.
  • Furthermore, there is an additional check for order statuses between Seller Center and the warehouse management system (OMS/WMS).
    • The statuses between these two systems are not always synchronized.
  • Additionally, there are checks that compare the products directly in the database.
    • These check whether the same amount of products is available in both systems.
    • This can be applied for either one Seller or per attribute set.

Dirty Products Monitor – Product to Sync Monitor

This view is outdated as most information within the displayed table is covered within the chapter for Product Sync Status. So even if products are marked as dirty for e.g. content or stock, it does not actually mean, they are still, as Seller Center is using a different approach to ensure product synchronization. 

The fields where data has been changed (e.g., as a consignment, cropped image, whether the product is synced with[out] an image, etc.) are marked red. The other columns are more relyable covered via the overview of Shop Update.

# Description Image
1
  • Go to Administration > Synchronization > Products

There is a list of all products that are synced to the Shop system.

  • If the row is empty for “SKU” and the content flag is red, this means that the product is newly created and has been pushed to the Shop backend for the first time.
Screen_Shot_2015-01-12_at_17_15_36

 

Stock Monitor

Stock monitor checks the stock values for the products in Seller Center and the Shop system. Seller Center uses the Shop Slave DB to compare the stock values. Seller Center does not regard stock reservations or any other blocking stock that is not released. On the Shop system, the value that is compared is the “Stock on inventory,” not the “Available stock.” The available stock already excludes order reservations.

# Description Image
1
  • Go to Administration > Synchronization > Stock
  • All affected Sellers are listed with the amount of products that are out of sync, the total stock amount in Seller Center, and the value in the Shop system.
  • If the value is empty it means that there is no stock in the Shop.
Stock_synchro
2
  • “Resync to Shop” button opens a confirmation overlay where it can be confirmed that the value from Seller Center will be pushed to the Shop.
resync
3
  • “Detail” button shows all affected products.
  • In this view, the stock can be resynced for specific products.

 

 detail_stock

 

Price Monitor

Price monitor checks the price, sales price, and sale price period values for the products in Seller Center and the Shop system. Seller Center uses the Shop Slave DB to compare the prices.

# Description Image
1
  • Go to Administration > Synchronization > Price
  • All affected Sellers are listed with the amount of products that are out of sync.
synchro_price
2
  • “Resync to Shop” button opens a confirmation overlay where it can be confirmed that the value from Seller Center will be pushed to the Shop.
price_resend
3
  • “Detail” button shows all affected products.
price_detail

 

Order Monitor

Order monitor compares the order item status in Seller Center to the status in the OMS system twice an hour. Seller Center does use the OMS API call getRawOrderItemStatusByIds to generate the differences. It compares the response field sc_status (source status) with the current status in Seller Center. If a discrepancy is found there, the data will be listed.

# Description Image
1
  • Go to Administration > Synchronization > Order Status
  • All affected Sellers are listed with the amount of order items that are out of sync.
Screen_Shot_2015-01-16_at_09_34_23
2
  • “Resync all order states from WMS”  button opens a confirmation overlay where it can be confirmed that the value from Seller Center will be pushed to the OMS system.
  • To sync the data to the OMS system, the OMS API call getOrderItemStatusById is used. In order to resync the data, the new status needs to be returned in the API response. Additionally, the transition needs to be valid to the Seller Center state machine. Otherwise, it will be ignored.
  • Possible transistions:
    • Ready to Ship => Shipped / Delivered
    • Shipped => Delivered / Failed Delivery
  • Not possible transitions:
    • Delivered => Canceled
    • Deliverd => Failed
    • Ready to Ship => Pending
    • Shipped => Canceled
    • Shipped = Pending
Screen Shot 2015-01-16 at 09.36.32
3
  • “Detail” button shows all affected orders and the status of each order item where there is a discrepancy
Screen_Shot_2015-01-16_at_09_39_02

 

Product Deviation Monitor

This feature compares the product data (regarding the amount of products) in Seller Center and in the Shop system. This is to prevent additional products from being accidentally created in the Shop system by users. Using this check, you can see if additional variation or products exist in the Shop system–but not in Seller Center.

When there are discrepancies between the systems, there will be a CSV download available that needs to be uploaded to the Shop system as a product update.

The result will be that the additional products have the status “Deleted” and don’t appear anywhere; this way, nobody can purchase them.

This check displays the data for the specific Seller according to attribute set.

# Description Image
1
  • Go to Administration > Synchronization > Product Deviation
  • All affected Sellers are listed with the amount of products that is in the Shop system but not in Seller Center.
  • The entries are already divided by attribute sets so that the upload of the CSV files is easier on the Shop system.
  • Click the “Download” button to export a CSV file for all additional data and save the file on your local disk.
Screen_Shot_2015-01-16_at_10_00_16
2
  • “Remover Record”  button opens a confirmation overlay where it can be confirmed that the value from Seller Center will be pushed to the Shop.

Deleting Products in the Shop Backend system

The following describes how products are imported in order to delete products within the Shop Backend system

# Description Image
1
  • Log in to the Shop system and go to Catalog > Product import / MDH import
1
2
  • Select the option “Product update” as the “Import Mode”
2
3
  • Choose for the field “Attribute Set” the value of the attribute set that was downloaded (short code for the attribute set is the file name).
3
 4
  • Select the file for the import.
  • Then, click “Upload file” to start the upload process.
4
 5
  • A preview table is loaded where the uploaded details are listed (SKU, status).
  • Click “Import” and the status changes are done.
  • Repeat this process with all files so that the system is cleaned up.
6

Attribute Set Deviation Deviation Monitor

This check is the same as described in the chapter before; only the view is different. Previously, it was displayed based on Seller. This view is based on attribute sets where the data of all Sellers is included.

# Description Image
1
  • Go to Administration > Synchronization > Attribute Set Deviation
  • All affected attribute sets are listed with the amount of products that are in the Shop system but not in Seller Center.
  • Click on the “Download” button to export a CSV file for all additional data and save the file on your local disk.
Screen_Shot_2015-01-16_at_10_25_22
2
  • “Remover Record” button opens a confirmation overlay where it can be confirmed that the value from Seller Center will be pushed to the Shop.

 

Images

This check is the similar as described in the chapter for stock or orders previously; the only change is that the Sellers are displayed with their respective amounts of image changes.

Description Image
  • Go to Administration > Synchronization > Image
  • All affected Sellers are listed with the amount of products that were changed in Seller Center and synced to the Shop system.

 

 image_sync2
  • Click on “Details” to see the products with their images that will be  synced.
image_sync

Seller

This check is in place to indicate which Sellers are currently in the queue and their reasons for being there.

Description Image
  • Go to Administration > Synchronization > Sellers
  • All affected Seller are listed with the amount of products that were changed in Seller Center and synced to the Shop system.
  • Red indicates that there has been a change.

“Status”: status in Seller Center (active / inactive) for the Seller

“Profile”: any profile update for Seller (e.g., change in address, etc.)

“Config”: any changes where a configuration has been sent to the Shop backend system, e.g. deactivation of Seller due to reaching the order limit.

 seller_sync