Graybeard
Well-Known Member
Read this first: OK I didn't spot the AI error
AI (ChatGPT) gets confused and makes an error, and me being a "almost trusting human" does not carefully check the code for tiny misunderstandings, assumptive, errors --in this case ',' and not '|' BIG ERROR with just one character ...
So, after an hour I spot the tiny error in my 2,000+ word instructions and code snippets file. now that is fixed ... relief
So now I can 'see' the feed in the correct column fields in the data base --STEP 2 fixed, Step 1 was cleaning the csv file --removing all non utf-8 characters (Chinese nonsense)
Now I sort unique and count all of the word in the 27,000 product descriptions:
Now I trend the most common (highest count ) relevant words with one of my Python scripts using regression analysis to interpret possible interest trends to select some products
Looks to me that wireless products would be the best to investigate followed by 'car' (or automotive)
So I make an initial SQL Query of my new database for this feed
Duplication is caused by models (color selections) but now I have my links to investigate further
OK, here is the catch: TomTop is shipping from China (Free Shipping [in most cases]) however I start checking prices at Amazon and Walmart for the same name brand product the prices are near identical and Amazon Prime will deliver in 2 days --WTF? It gets worse I check eBay and the prices are a bit less and some sellers will ship free in 5-8 days locally (USA). SO WHERE IS THE VALUE PROPOSITION OF TOM TOP? NOWHERE!
5 Hours of my day frustratingly wasted with Share A Sale and Affiliate Marketing !!!
</rant>
AI (ChatGPT) gets confused and makes an error, and me being a "almost trusting human" does not carefully check the code for tiny misunderstandings, assumptive, errors --in this case ',' and not '|' BIG ERROR with just one character ...
So, after an hour I spot the tiny error in my 2,000+ word instructions and code snippets file. now that is fixed ... relief
So now I can 'see' the feed in the correct column fields in the data base --STEP 2 fixed, Step 1 was cleaning the csv file --removing all non utf-8 characters (Chinese nonsense)
Now I sort unique and count all of the word in the 27,000 product descriptions:
Bash:
$ sed 's/ /\n/g' tomtop-word.csv | sed -e 's/\W//g' -e 's/.*/\L&/'\
|sort|uniq -c |sort -nr |sed -e 's/^[ \t]*//;s/[ \t]*$//' -e 's/ /,/' > tomTopKW.csv
barry@DS-11:... $ head -n30 tomTopKW.csv
9875,for
8923,with
4178
3029,light
2887,portable
2682,car
2289,and
2083,camera
2078,digital
2070,electric
2054,led
1942,control
1934,wireless
1881,bag
1863,mini
1663,outdoor
1609,set
1595,waterproof
1541,fishing
1499,tool
1485,kit
1483,machine
1475,usb
1436,home
1398,battery
1371,display
1334,smart
1325,remote
1286,high
1240,waterLooks to me that wireless products would be the best to investigate followed by 'car' (or automotive)
So I make an initial SQL Query of my new database for this feed
Duplication is caused by models (color selections) but now I have my links to investigate further
OK, here is the catch: TomTop is shipping from China (Free Shipping [in most cases]) however I start checking prices at Amazon and Walmart for the same name brand product the prices are near identical and Amazon Prime will deliver in 2 days --WTF? It gets worse I check eBay and the prices are a bit less and some sellers will ship free in 5-8 days locally (USA). SO WHERE IS THE VALUE PROPOSITION OF TOM TOP? NOWHERE!
5 Hours of my day frustratingly wasted with Share A Sale and Affiliate Marketing !!!
</rant>
