|
|
 |
 |
Joined: 5/8/2012
Posts: 26
|
|
|
Hi Kevin
As the categories didn't import I was trying to adjust them manually through the Store Admin but it is very time-consuming, so I have created another page and installed the BuyNow module again, I have cleared the cache and Restarted the DNN application, but this time the categories do not show at all.I have been into Edit of a few products and when I click on the Categories tab no categories show.
I have not been able to attach a file, but is there is someway i can send you the xls file just to check that I have the categories correct?
Regards
Glynis
|
|
|
|
 | |
|
|
|
Joined: 1/1/0001
Posts: 0
|
|
|
Hi Glynis,
When you imported on your second BuyNow module, did the import spreadsheet include Products and Categories or only Categories?
If you would like us to take a look at your xls file to see if we can spot any noticeable problems with the file, you can submit a free help desk ticket and attach the file here: https://www.smith-consulting.com/Foru...
Thanks,
|
|
|
|
| |
|
|
|
|
Joined: 5/8/2012
Posts: 26
|
|
|
Hi Kevin, Have put in the ticket as your suggestion. Thanks
|
|
|
|
| |
|
|
|
Joined: 1/1/0001
Posts: 0
|
|
|
Hi Glynis,
I took a look at the spreadsheet you submitted with your ticket and at first glance I it is not in the correct format. You have 8 incorrect Columns (A - H) before the Categories column. (Please see screenshots below). It is important that the columns are in the correct order, exactly how they are in the sample spreadsheet.
Incorrect Format:
Correct Format:
|
|
|
|
| |
|
|
|
|
Joined: 5/8/2012
Posts: 26
|
|
|
Hi Kevin, Sorry I don't know how, but I attached the wrong xls file. The one I used is in exactly the correct order - I have uploaded it in the same way I did the previous one, on a ticket.
Thanks Glynis
|
|
|
|
| |
|
|
|
Joined: 1/1/0001
Posts: 0
|
|
|
Hi Glynis,
I just created a clean installation of DNN 6.2 with the latest version of the Cart v.5.0 and uploaded the import xls file you provided and was successfully able to view all your products (See screenshot below).
I am not sure the issue I am looking for regarding the Categories, I am showing 802 Products and 107 Categories in the database. I did however notice that in your spreadsheet, some lines in the Categories column have a double "~", are these Categories the one not being imported? Please see screenshot below.
Thanks,
|
|
|
|
| |
|
|
|
|
Joined: 5/8/2012
Posts: 26
|
|
|
Hi Kevin, Thank you for all the time you are spending trying to help me. I had noticed the double ~~ - have removed them and tried to import again into a new instance of the cart but I still get no categories at all. I am now wondering if it is anything to do with the DNN version we are using - we are on 06.00.02 (72). What I can't work out though, is that the second time I added the Smith Cart and imported (5 days ago), I did get categories, although they were not correct on the spreadsheet at the time - so I am now thinking that how can it be the DNN version when it did import the categories on one of the occasions! I didn't really want to upgrade DNN at this time - but if you think that is the problem then I will have to try to schedule it in.
Looking at the images above, I am wondering if I have read the syntax in the example correctly. I thought that, for example, Skin Care~Men~After shave;Skin Care~Brands~North for Men (all in cell A2) would display the product in Category Skin Care, sub category Men, Sub category After shave and also in category Skin Care, sub category Brands, sub category North for Men - have tried to sent a sample xls file (category sample.xls) through the ticket but can't do it .
|
Main Category |
Sub Category |
Further sub category |
|
Skincare |
Daily care |
|
|
|
|
Anti-ageing |
|
|
|
Cleansers |
|
|
|
Day creams |
|
|
|
Eye creams |
|
|
|
Night creams |
|
|
|
Toners |
|
|
Men |
|
|
|
|
After shave |
|
|
|
Other |
|
|
|
Shaving products |
|
|
Special care |
|
|
|
|
Blemish control |
|
|
|
Facial masks |
|
|
|
Peeling |
|
|
|
Serums |
|
|
|
|
|
|
Brands |
Aqua-Rhythm |
|
|
|
Bioclinic |
|
|
|
Diamond Cellular |
|
|
|
Ecobeauty |
|
|
|
Ecollagen |
|
|
|
Essentials |
|
|
|
North for Men |
|
|
|
Optimals |
|
|
|
Optimals BioMaximum+ |
|
|
|
Optimals Cleansers |
|
|
|
Optimals Nutri Calm |
|
|
|
Optimals Optimals Time Relax |
|
|
|
Optimals Oxygen Boost |
|
|
|
Optimals Skin Energy |
|
|
|
Pure Nature Aloe Vera & Arnica |
|
|
|
Pure nature Blueberry & Lavender |
|
|
|
Pure Nature Masks |
|
|
|
Pure Nature Organic Açai & Pomegranate |
|
|
|
Pure Nature Organic Red Apple & Oat |
|
|
|
Pure Nature Organic Tea Tree & Rosemary |
|
|
|
Pure Skin |
|
|
|
Royal Velvet |
|
|
|
Self Tan 2008 |
|
|
|
Swedish Spa |
|
|
|
Tender Care |
|
|
|
Time Reversing |
|
|
|
Time Reversing InTense |
|
Make Up |
blah blah |
|
|
|
|
blah blah |
|
|
|
blah blah |
|
|
|
blah blah |
|
|
|
blah blah |
|
|
|
|
| |
|
|
|
 |
Joined: 1/28/2011
Posts: 19
|
|
|
Kevin -
I've been working with the Smith_Products table in SSMS. After the initial import, I execute a custom query to update the CategoryID field. I haven't spelunked into the code or stored procs that you may have involved with the import method, but it seems that one of the stored procs that would update the CategoryID field may not be executing. I don't see any errors in the log files.
Mike
|
|
|
|
| |
|
|
|
Joined: 1/1/0001
Posts: 0
|
|
|
Hi Glynis,
Currently the Cart allows you the ability to import an unlimited number of categories and sub categories per product. Regarding the ability to import multiple sub-sub categories per product I believe you may have come across a limitation that hasn't been programmed into the cart yet. If you have budget in your project and would like to to sponsor a portion of the development, we can provide you with a fixed quote if you submit a quote request at the following link: http://www.smith-consulting.com/servi...
Thanks,
|
|
|
|
| |
|
|
|
|
Joined: 5/8/2012
Posts: 26
|
|
|
Hi Kevin, Yes, I believe you are correct that the problem was because of the sub sub categories.
However, I would just like to post here for anyone else experiencing similar problems what i have actually done to resolve the issues:
When I had removed the BuyNow module although the module was deleted, the actual data that had been imported stayed in the database so each time I was trying to import again - with some differences in the xls file - there was a problem. Following your advice I deleted the contents of the Smith_Products table but still the categories were wrong, so I then deleted the contents of the Smith_Category and the Smith_Category_Product tables.
After deleting these I was able to successfully import from the new xls file - the only problem then was of the sub sub categories which I have now resolved manually.
Glynis
|
|
|
|
| |
|
|
|
Joined: 1/1/0001
Posts: 0
|
|
|
Hi Glynis,
Thanks for the additional info. To clarify the behavior of the import program, when importing your products the program will look up products by sku, if the product currently exists in the database the import program will update the existing product and if the product sku does not exist the import program will insert a new record in the database. If you want to re-upload all your Products, first deleting the data from you db located in the Smith_Products, Smith_Category, and the Smith_Category_Product tables.
Kind Regards,
|
|
|
|