Item Filters - How to accept or ignore specific products

Item Filters - How to accept or ignore specific products

Extensiv Integration Manager  offers the ability to set up either a whitelist or a blacklist. This can be used to either ignore certain products, or to split fulfillment of your product list between multiple locations and have Integration Manager  only pull specific products/orders.

This setup affects both the order and inventory sync. Items not matching the whitelist/blacklist setup will not have inventory synced with the shopping cart.

Step-by-step setup guide
  1. Under each cart within Integration Manager  there is an Item Filters section:
       

  2. The Item Filter feature offers two settings.

    Filter Type: This defines how Integration Manager  should apply your list of products.
  1. Whitelist - Cart inventory will only send updates for SKUs that are on this list. Only order lines with skus that are on this list will be accepted.
  2. Blacklist - Cart inventory will send updates for all available SKUs that are not on this list. Order lines with skus that are not on this list will be accepted
Filter Level: The defines what Integration Manager  should do if we encounter a filtered item.
  1. Filter Item - The order line rejected by the filter will be marked as filtered in Integration Manager  and will not send on to the WMS. These lines will be crossed out in the order details page.

  2. Filter Order - Any order with an order line caught by the filter will be completely refused by Integration Manager  and will not be downloaded or sent to the WMS.

Choose whichever list type will be easier for you to maintain.

Example:

A merchant sells 100 products on their Shopify store. Of the 100 products, 10 of them are drop shipped from the manufacturer. The remaining 90 products ship from their third party fulfillment center. They use Integration Manager  to send orders to their fulfillment center, so they have set up a blacklist containing the 10 SKU's shipped from the manufacturer. Integration Manager  ignores these 10 SKU's when downloading orders from Shopify.

Wildcards

Integration Manager  supports using the % symbol as a wildcard character in your item filters. If you would like to filter out a group of products using a common pattern in the SKU you can do so by adding % anywhere in/before/after the shared pattern.

Example:

A merchant has 3 products with SKUs starting with TESTSKU. Rather than write the individual SKUs for each product they can instead use the wildcard.



If you are using product aliases in Integration Manager, please keep the following in mind:
  • When downloading orders, Integration Manager compares the SKU on the order to the whitelist/blacklist before any alias conversion has taken place. So use the SKU in the shopping cart.
  • When uploading inventory, Integration Manager compares to the SKU from the WMS/OMS to the whitelist/blacklist.

Because of this, you may need to add both the shopping cart SKU and the WMS/OMS SKU to the whitelist/blacklist if you have setup Integration Manager to perform alias conversions.

Integration Manager can also whitelist or blacklist other order fields. See Filter Orders

Bulk Uploading

The Integration Manager interface does not support bulk uploading of item filters. If you would like to do so, please contact Integration Manager support with a spreadsheet of filter values to load (one per line). Integration Manager charges a one-time bulk data upload fee.



    • Related Articles

    • Some Orders Not Syncing from Cart to WMS

      Problem Some Orders are not flowing from your shopping cart to your WMS or backend system. Solution Check Skipped Orders Browse to the Orders tab and click the Show Skipped Orders button. If Extensiv Integration Manager knowingly skipped any orders, ...

    • Extensiv Integration Manager Support Options

      You can view your support options and contact support any time by logging into Integration Manager and selecting the Support tab. Support Hours Support is currently offered from 8am to 5pm Pacific time. Standard Support All Integration Manager ...

    • Filter Orders

      Extensiv Integration Manager offers the ability to load or ignore orders based on specific data fields. The most common use case for this is to only load orders shipping to specific countries and ignore all other orders. Step-by-step setup guide ...

    • Product aliases in Extensiv Integration Manager

      What is a product alias (aka. identifier)? Product aliases are unique values that identify product variants. (e.g. SKU, Listing SKU, UPC, MPN, ASIN, Internal Product ID, etc.) A single product variant may have many product aliases/identifiers.  Why & ...

    • Tracking Not Syncing from WMS to Cart

      Problem All or some of your shipment/tracking records are not syncing from your backend WMS to your shopping cart. Solution If Nothing Is Syncing Ensure Cart Shipment Upload is Enabled Browse to your cart settings by going to Carts > Select your cart ...