BigCommerce Products without a SKU (Parent Products)

Hello,

One of our customers has multiple (300+) situations where there exists a parent item without a SKU. These Parent "shell" items would never have a SKU or be purchaseable.

We're observing 300+ errors whenever we run our BigCommerce Product to NetSuite Item Mass Update (find/update of the Celigo BigCommerce Item ID Map).

In an attempt to resolve, I created Celigo BigCommerce Item ID Map records on a placeholder item and attempted to modify the search parameters to find existing records:

[[["custrecord_celigo_bg_siim_productid","is","{{{product_id}}}"],"AND",["custrecord_celigo_bg_siim_nsid","is","BigCommerce Placeholder Parent Item (No BigComm SKU)"]],
"OR",[["custrecord_celigo_bgc_biim_bgc_storeid","is","{{{storeid}}}"],"AND",["custrecord_celigo_bg_siim_nsid.nameinternal","is","{{{sku}}}"],"AND",["custrecord_celigo_bg_siim_nsid.isinactive","is","F"]]]

Unfortunately the above has not worked.

We do have a ticket open in an attempt to resolve this. Has anyone in the community encountered this issue with respect to BigCommerce?

  • We're open to applying an output filter relative to BigCommerce, but this doesn't seem to be available in the integration app.

Any ideas, tips/tricks, or recommendations are greatly appreciated.