Advanced Retail (UK) Ltd
Company Wiki

As per https://advancedretail.freshdesk.com/helpdesk/tickets/193005

-- check status
SELECT * FROM websites.vw_WebsiteInterfaceProducts_ProductListing WHERE barcode = '9781784162344'
SELECT * FROM websites.vw_WebsiteInterfaceProducts_ProductListing WHERE barcode = '9780241974988'
 
Currently showing an interface error.

Need to check whether a reference already exists in Shopify:
SELECT * FROM websites.vw_ProductSnapshotShopify  WHERE sku = '9781784162344' OR variant_barcode = 
'9781784162344'
SELECT * FROM websites.vw_ProductSnapshotShopify  WHERE sku = '9780241974988' OR variant_barcode = '9780241974988'

-- no match 

-- Should therefore be simple to get relisted by resetting the status and removing the last error:
-- You can use the following sproc to do this, but use with the greatest of caution:
  
EXEC websites.traxs_ProductInterface_ForceRelist_USE_WITH_CAUTION
    @site_no = ?,
    @product = ?