I am using a csv file for this…
when I take the csv file supplied to me from my source it catagories already, I want to be able to dump there products in ints own catagory BUT keep there catagory for subs. How do I do that?
In the excel header of course there is a catagory, for this I use (example) warehouse two. Now inside that warehouse/catagory I want to update the products with new inventory counts and of course new in stock products, To do this I need to call there catagory something… I thought I could just make one catagory in the header and make there catagory Secondary catagory but that didnt work…
Can someone tell me how to dump there row of catagories where I need them to go?
I want it to go to like warehouse one then to Lava lamps catagory which would then really be a sub. Each wholeseller I use is assigned there own warehouse (catagory) and in there would be all there catagories.
Hope I explained this good.
Thanks
or would i just not put in catagory into the feed and replace there catagory word in the header to say secondary and it would know that there are sub catagories already with that catagory? Or am I missing something.
this allows me to do 2 things… update inventory counts AND add new products at one time… Without being able to do this I have to manually add every new item manually which would be a pain.
If you want a product to drop into a the subcategory of artwork you would seperate by /// eg
So your heading of that column would be Category and in that column you would have as below
Warehouse one///Home and Garden///artwork
so whatever Product code relates to the line would drop into the artwork category. Be carfule as any spelling mistakes or upper/lower case typos would create a new category. So “Home and Garden” would be different than “home and garden”
John
[quote name='johnbol1' timestamp='1337773925' post='137100']
If you want a product to drop into a the subcategory of artwork you would seperate by /// eg
So your heading of that column would be Category and in that column you would have as below
Warehouse one///Home and Garden///artwork
so whatever Product code relates to the line would drop into the artwork category. Be carfule as any spelling mistakes or upper/lower case typos would create a new category. So “Home and Garden” would be different than “home and garden”
John
[/quote]
HI John
There is no way to do it otherwise? The problem is that in the feed there is 20 catagories so I would have to manually enter all that info to that column for expample
if there is catagories that are artwork and lamps then I would have to go into the feed and manually enter the warehouse six// in front of artwork as you suggust. BUT what if there is tons of catagories? Is there a fast way to do that?
that would work Warehouse one///Home and Garden/// IF the whole feed was being dumped in home and garden… But there now… If i simply do for example a quantity feed it gives me the product code and the quantity… when I upload that it updates everything no matter where it it BUT if its not yet in my database it creates a new catagory (products) and dumps EVERYTHING in there. SO, I then have to manually enter the rest of the info and place it in its right catagory. when the wholeseller adds 96 items into the feed which is NOT on the site already, I have to manually enter the 96 info's unless I can manupilate it in the feed before upload. you just cant hit ctrl v and find and replace artwork with Warehouse one///Home and Garden/// in front of the word because then you will be doing that for ALL of them and out of the 96 there might only be 3 going into that catagory…
Easy enough, just use concatenate in excel to add all columns together (remember to have a column with just /// in it)
or find and replace say “artwork” with ///artwork then combine all columns
John
OK, doing gret.
Just one more thing… so I noticed that google has disapproved some of my products because at the time of the crawl I was still moving things around and so it went to a moved page. These products are there and everything is done. I resubmitted the feed and the same ones were disapproved instantly. So, google is showing 50% of the products. I realized that they will auto deny based on the NAME and the URL that that product goes to so knowing that I changed all of those product name to include the product code in the name so in other words it use to be
8 oz Stainless steel flask
NOW IT SAYS
8oz Stainless steel flask 11-52
I did this thinking that in the feed the Product name makes the URL for that item but in fact it stayed the same… SO, what I am trying to do is go from
stevenssupplycenter.com/8oz-stainless-setel-flask.html
TO
stevenssupplycenter.com/8oz-stainless-setel-flask-11-52.html
If I am able to do this then those items will no longer be searched the original way to auto disapprove but to the new name which will then be indexed again because it is a NEW url.
How do I do this?
Thanks
OH and those url's are example and wont go to a page (i dont think)
ok so playing around with 1 product i discovered that if i delete the whole product and add it back thru feed then it changes the url like I need it to BUT is there an easier way then to delete 7000 and start over?
It's the SEO name which can be edited in the product details addon tab.
If you want to start over with all of them then uninstall and reinstall the SEO addon or you can run a db query to truncate the SEO names.
Edit: Also google will not approve the products until it has crawled them once again so you are not going to see the results immediately.
Submit a new feed with a different name.
John