As an administrator, a good feature of a shopping cart would be the ability to search orders by products sold. Unfortunately, the BigCommerce cart does not have this feature yet, so, this article will show you how to add this functionality.
The solution presented below only works with Mozilla Firefox.
The Concept
The whole idea is to install a script that would connect to the BigCommerce store API and take the information needed. All you have to do is to input the name of the product and hit search: the system will do the rest! A list with all possible matches will be displayed and you will have the possibility of selecting the searched product. After hitting "OK", the browser will open another window/tab and all the orders containing that product will be shown!
Installation
In order to work, this script needs Greasemonkey to be installed. Well, I hope you remember how to install it, and, ideally, I hope it's already installed. Don't worry even if you do not have any idea of what Greasenomkey represents. We have solutions for almost everything! Take a pick here and see a full documentation.
"drag-and-drop"
I guess you already suspect what needs to be done in order for this script to be installed. Yes, you are right: drag-and-drop! So, download the file below (right click > save as..) and then, drag-and-drop it into a Firefox opened window. When asked, click "Install" and that is pretty much it!
As of this moment, your store can search for orders by products sold.
How to make use of the new functionality
Like mentioned above, this script uses the BigCommerce API. So, make sure the current user has access to API: Users > edit the user > scroll down the page and tick the box that's saying "Yes, allow this user to use the API". While on this page, make sure you copy the API Token because we're gonna need it. Do not forget to save!
Let's move on now! Because we are talking about orders we need to go to the right place first: Orders > View Orders. At the top of the page, above the breadcrumbs, you will see some text boxes and buttons.
- User - is the name of the user you enabled the API access for; i.e.: admin
- API Token - is the API token of the user you enabled the API access for; i.e.: fda2115dy411654ch402dfe0ede1adb1 (remember I was saying to copy this token when we enabled the API access for the users)
The rest of the buttons are:
- Connect to API - connects you to API and takes the needed info
- The search function - is a regular search: just input the keyword and hit search
- The results drop-down - is a menu with all the products returned by your search
- OK - after selecting a product from the drop-down, once pressed, this button will open a new window/tab with all the orders containing the product selected
Using the script presented in this article, the system may ask you to provide again the API credentials (the user name and the API token) when connecting to the API database. So, if you find this as uncomfortable you can use the simplified version of the script.
If you have any improvements, or would like to say thanks just comment below!