GORILLA_SKUSTATUS() – Get the active or inactive status of the SKU
As explained in the tutorial video, the GORILLA_SKUSTATUS() function did not include a ‘fulfillment’ filter back then. We have now added this filter, allowing you to easily retrieve fulfillment status (FBA/FBM) information
Sample Usage
🚨 Use ranges (e.g.A2:A1000) in your formula wherever possible for quicker results and to prevent Google from blocking your account for 24 hrs due to overloading their resources.
=GORILLA_SKUSTATUS("TOY STORE", "US", A2:B100)=GORILLA_SKUSTATUS("TOY STORE", , A1:A1000)Syntax description
Description:
Bulk return the list of SKU’s status in your account.
Syntax:
GORILLA_SKUSTATUS(Seller ID, [marketplace], sku, [fulfillment] )
Seller ID – REQUIRED
Enter the seller ID or nickname you entered in your Gorilla account.
Marketplace – OPTIONAL
Marketplace filter. Use All for all marketplaces and Default for the seller default. Other valid values are country codes US, IT, etc.
SKU – REQUIRED
The ASINs or SKUs to get the status of.
Fulfillment – OPTIONAL
‘ALL’ shows any SKU matching the search criteria. ‘FBM’ displays fulfilled by merchant SKU’s only. ‘FBA’ displays fulfilled by Amazon SKU’s only. Default is set to ‘ALL’.
Examples:
🚨 Use ranges (e.g.A2:A1000) in your formula wherever possible for quicker results and to prevent Google from blocking your account for 24 hrs due to overloading their resources.
=GORILLA_SKUSTATUS("TOY STORE", "US", A2:B100)This will return “active” or “inactive” for all the ASINs or SKUs listed from A2 to B100 for the US marketplace. The function supports 2D arrays such as a set of values in column A and column B.
=GORILLA_SKUSTATUS("TOY STORE", , A1:A1000)If the marketplace is left out, it will get the listing status of the ASIN/SKUs from the default marketplace associated with your account. Use ranges in your formula to get the results in bulk.