×

Special Instructions: Using Variant Items With Shopify

To properly utilize Variant Items with your connector system, you must first ensure the variants exist on both sides of the system - Shopify and BirdDog. You must then manually create an Item linkage with the appropriate values:

  • ConnectorID - ID for the Shopify connector (BDConnectorAccounts.ID)
  • Type = 'item'
  • LocalID = '{item_no}'
  • RemoteID = '{Shopify Product ID}'
  • RemoteID2 = '{Shopify VariantID}'
  • Note
    • When viewing a variant on Shopify the url will be in the following format: https://admin.shopify.com/store/{Your store}/products/{Shopify Product ID}/variants/{Shopify VariantID}
    • There MUST be a linkage for every item where RemoteID is blank to represent the master product.
    • Example of a product with 3 variants:PRODVAR1,PRODVAR2,PRODVAR3
    • PRODVAR1
      • LocalID - PRODVAR1
      • RemoteID - {Shopify Product ID}
      • RemoteID2 - blank
      • Type = item
    • PRODVAR2
      • LocalID - PRODVAR2
      • RemoteID - {Shopify Product ID}
      • RemoteID2 - {Shopify VariantID}
      • Type = item
    • PRODVAR3
      • LocalID - PRODVAR3
      • RemoteID - {Shopify Product ID}
      • RemoteID2 - {Shopify VariantID}
      • Type = item

 For example, this is the sequence I would want to follow.

  • Create 3 new items in my local ERP
    • Parent30
    • Parent30_3
    • Parent30_10
  • Create the same 3 new items on Shopify
    • Parent30 - SKU: Parent30 - ProductID: 8180204863768 / VariantID: 44705488994584
    • Parent30_3 - SKU: Parent30_3 - VariantID: 44705489027352
    • Parent30_10 - SKU: Parent30_10 - VariantID: 44705489060120
  • Run the SQL queries to create my linkages
    • INSERT into BDConnectorLinkages (ID,LastUpdate,LastUpdated_By,RecordRevLevel,Created,Created_By,ConnectorID,LocalID,LocalID2,LocalID3,LocalID4,LocalID5,RemoteID,RemoteID2,RemoteID3,RemoteID4,RemoteID5,Type,Failed,UpdateFailed,DownloadFailed,DownloadFailedTriedThisRun)
      Values (NEWID(), '2023-03-03 13:52:17.190', '1234EAAA-9FDD-99E9-5555-EE1239991645', '0', '2023-03-03 13:52:17.190', '1234EAAA-9FDD-99E9-5555-EE1239991645', '210FC3DB-7F88-4FD1-B623-53FA477C5828', 'PARENT30', '', '', '', '', '8180204863768', '', '', '', '', 'item', '0', '0', '0', '0')


    • INSERT into BDConnectorLinkages (ID,LastUpdate,LastUpdated_By,RecordRevLevel,Created,Created_By,ConnectorID,LocalID,LocalID2,LocalID3,LocalID4,LocalID5,RemoteID,RemoteID2,RemoteID3,RemoteID4,RemoteID5,Type,Failed,UpdateFailed,DownloadFailed,DownloadFailedTriedThisRun)
      Values (NEWID(), '2023-03-03 13:52:17.190', '1234EAAA-9FDD-99E9-5555-EE1239991645', '0', '2023-03-03 13:52:17.190', '1234EAAA-9FDD-99E9-5555-EE1239991645', '210FC3DB-7F88-4FD1-B623-53FA477C5828', 'PARENT30_3', '', '', '', '', '8180204863768', '44705489027352', '', '', '', 'item', '0', '0', '0', '0')


    • INSERT into BDConnectorLinkages (ID,LastUpdate,LastUpdated_By,RecordRevLevel,Created,Created_By,ConnectorID,LocalID,LocalID2,LocalID3,LocalID4,LocalID5,RemoteID,RemoteID2,RemoteID3,RemoteID4,RemoteID5,Type,Failed,UpdateFailed,DownloadFailed,DownloadFailedTriedThisRun)
      Values (NEWID(), '2023-03-03 13:52:17.190', '1234EAAA-9FDD-99E9-5555-EE1239991645', '0', '2023-03-03 13:52:17.190', '1234EAAA-9FDD-99E9-5555-EE1239991645', '210FC3DB-7F88-4FD1-B623-53FA477C5828', 'PARENT30_10', '', '', '', '', '8180204863768', '44705489060120', '', '', '', 'item', '0', '0', '0', '0')

  • Update Quantity on Hand for all 3 new items in my local ERP.
  • Run the Connector. At this point, the two should be linked.