Menu
Feedback
Start here
Tutorials
Developer portal

Known Issues
Support Rules
Troubleshooting

Frequently Asked Questions
Announcements
Tutorials
Tutorials
Explore in-depth tutorials for operating your VTEX store.
Tutorials
Orders
All orders
How to rank the best selling items
How to rank the best selling items

The Orders module was not designed as a Business Intelligence (BI) tool. It's usually through the ERP that the store has access to sales reports.

While the Orders module primary goal is to manage the order flow, it is possible to manipulate data from the order report to extract information that may be useful to your business.

To get a list of SKUs sold in a certain period by order of top sellers, follow the steps below:

  1. In the VTEX Admin, go to Orders > All Orders, or type All Orders in the search bar at the top of the page.
  2. Using the filters, choose the period you want information about.
  3. Click the Export button in order to export orders.
  4. Open your email and download the link within 72 hours; the link will expire after that period.

Each line corresponds to an SKU purchased in a particular order. In the Quantity_SKU column, you have the SKU quantity for that order. And in the ID_SKU column, you have the SKU ID.

Therefore, you can use Excel to count how many times each SKU appears (ID_SKU), also taking into account cases where the SKU quantity for the same order is greater than 1.

Example: in the case below, the SKU of ID 009 appears twice, both with quantity 1. Therefore, the total quantity for this SKU is 2. The SKU of ID 034 appears only once, but with quantity 2, so its total quantity is 2 as well. The other SKUs (001 and 050) appear only once, with quantity 1. So the total quantity of each of these SKUs is 1.

Quantity_SKUID_SKU
1001
1009
2034
1050
1009
Contributors
2
Photo of the contributor
Photo of the contributor
+ 2 contributors
Was this helpful?
Yes
No
Suggest Edits (GitHub)
Contributors
2
Photo of the contributor
Photo of the contributor
+ 2 contributors
On this page
Still got questions?
Ask the community
Find solutions and share ideas in the VTEX community.
Join our community
Request support from VTEX
For personalized assistance, contact our experts.
Open a support ticket
GithubDeveloper portalCommunityFeedback