- This topic has 4 replies, 4 voices, and was last updated 3 years, 9 months ago by
.
-
Posts
-
-
Let me preface this by saying I have zero programming skills lol. However, I’m thinking about trying to learn some. I’d like to look at the data we can pull from the Report Orders CSV and sort items sold according to personalized categories. Yes, ebay shows you data according to their own categories but some items I have span multiple categories (in my head) or the ebay category is too general for the multiple kinds of items I sell within it.
For instance, if I sell madras shorts/pants, the defining feature for me is that they are men’s madras bottoms. But ebay will break it up into shorts or pants as separate categories, when I want to know how well madras bottoms as a whole sold in a given month. Or even looking at things like brand, size, etc.
I’d have to come up with some decimal system for the custom field to start.
How would I go about doing something like this?
-
-
Welcome to the glorious world of Excel! (and the nightmare horrorscape that is the eBay CSV datafile).
Anythng you do with that CSV file will likely need to updated line by line. I find it mind-numbing how messy that data is.
2 very powerful looks you should learn about are Pivot Tables and Look up tables (command vlookup).
The great thing about excel, is there a million tutorials on line. Just go google and type “How do I use Pivot tables in excel” and you will find dozens of videos or step by step web guides. There is zero need to pay for any services. There is so much free information out there.
Further if there is anything you every want to do in excel, just type the query into google and answer will pop up. For instance if you wanted to know the number of days between to dates, just type “how do I calculate the number of days between 2 dates in excel”. It will come up.
Menu options in Excel can vary between versions and platforms (i.e. Mac Vs Windows). So you may need to specify what version you are working with.
Good luck.
-
If you have a store, you might want to create your own custom Store Categories. I assume this data would show up in the CSV files as well, but I don’t have it in front of me to confirm.
Managing your eBay Store | eBay
As for Excel, it can do amazing things, but you need to learn formulas. As Debitendcredits pointed out, Google will be your friend. Here’s a formula I came up with to classify whether your items are Madras Bottoms or Not Madras Bottoms. Obviously, you would need to do additional work for other categories. This formula assumes the title of the ebay item is in column A.
=IF(AND(COUNTIF(A2,”*madras*”)=1,OR(COUNTIF(A2,”*short*”)=1,COUNTIF(A2,”*pant*”)=1)),”Madras Bottoms”,”Not Madras Bottoms”)
In English, here’s the simple translation. If your title (in cell A2) has the word “madras” AND it has either the word “short” or “pant” in the title, then it will show “Madras Bottoms.” If the title doesn’t meet that criteria, it will show “Not Madras Bottoms.”
-
@debitendcreits Yes it’s crazy to me how much data ebay collects and how messy it is, or not tracking metrics that seem important! Haha
@Zach Thank you, that formula sounds like a helpful place to start!
-
- You must be logged in to reply to this topic.