How to fetch data #
You can fetch data in two ways. Either click on the Build Workbook button, which will reset and rebuild everything and fetch all data, or click on the individual fetch data buttons. The latter is recommended when you are fetching individual data to update a particular sheet.
What happens when you fetch data #
When you click on any fetch data button, the first action the add-in does is wipe the sheet completely. This is much quicker and uses up fewer resources than comparing data present and only fetching new ones. Data fetching and creation are subject to the limitations mentioned in the corresponding section of our documentation. We recommend always keeping data updated in order to speed up the process of creating products. When you make changes to your store, it is always a good idea to do a fresh data fetch.
Buttons #
Fetch Products #
This button fetches all simple products and all variations of variable products, both draft and published, including product descriptions if you chose to do so in the settings.
You can then use the built-in Excel filters to customize your view.
Variable products are not fetched, only their variations. If a variable product has no variations, nothing will be output in the sheet.
You can distinguish between simple products and product variations by looking for the presence of an ID in the variable ID column (VB ID). Only variations will have a variable ID.
Fetch Attributes #
This button fetches all attributes and their corresponding terms. The data in this sheet are later used in product creation to speed up the process. Please don’t make any changes to this sheet. Adding, deleting, or changing data, might lead to errors when creating products.
Fetch Categories #
This button fetches all product categories. The data in this sheet are later used in product creation to speed up the process. Please don’t make any changes to this sheet. Adding, deleting, or changing data, might lead to errors when creating products.
Fetch Buyers #
This button fetches all buyers. The data in this sheet are also used later while fetching orders to quickly identify the customer. Please don’t make any changes to this sheet. Adding, deleting, or changing data, might lead to errors when fetching orders.
Fetch Orders #
This button fetches all orders, regardless of status.
Heads up #
All the above buttons fetch data and output them in the corresponding sheets. The data in these sheets are for information purposes and may be used during product creation and/or further data fetching. Making changes to the data in these sheets should be avoided for the reasons we mentioned above and for the added reason that changes to these sheets are in no way reflected in your store.
