Looking to migrate to ZenCart from OSC

DigiBooks:

Well after a bit of playing around I have blended the CSS Flyout Menu into the new site template. Love to know what you all think.

http://digibooks.org.uk/TESTBED

Generally looks good. On a blackberry 9930, though the center area slightly overlaps theleft sideboxes (the arrow isalmost not visible) and then not sure if on purpose or not each flight out menu overlaps the previous to cover the arrow and then some.

mc12345678:

Generally looks good. On a blackberry 9930, though the center area slightly overlaps theleft sideboxes (the arrow isalmost not visible) and then not sure if on purpose or not each flight out menu overlaps the previous to cover the arrow and then some.

Appreciate your feedback. OK I haven't taken Blackberry (or similar) into consideration as the site is aimed at downloading multi-format zip files to PC and then uploading to Kindle or other e-book reader. I'll check it out on my Kindle Fire HD and see how it looks.

OK I see your point ... even on the PC as each fly out runs it covers the arrow from the previous left-hand element. I'll take a look into that as the fly-out is based on the original sidebox width of 150px whereas the Bookshelf tempate requires the settings to 175px. So obviously I need to change something else to get the fly-out clear of the previous menu item.

DigiBooks:

OK I see your point ... even on the PC as each fly out runs it covers the arrow from the previous left-hand element. I'll take a look into that as the fly-out is based on the original sidebox width of 150px whereas the Bookshelf tempate requires the settings to 175px. So obviously I need to change something else to get the fly-out clear of the previous menu item.

Think it is all now sorted ... I had missed changing one 150px size to 175px :/

And I've switched off changing the background color on hover to preserve all the arrows.

Okay guys ... I did say at the start that I would need your hep from time to time initially so I'm hoping someone here can help me please.

I have successfully converted the OSC Products to ZenCart. As I mentioned earlier OSC does not allow you to pick and choose where you want to store images. So I have Author images and Book Covers which I want to store in 2 separate folders.

I did a test to upload a new author image for an exiting author and find that in the database instead of it showing "James Patterson.jpg" it now shows "authors/James Patterson.jpg" ... perfect!

I am not brilliant with MySQL at this time ... so is there a simple way I can prefix every image with "authors/"? Either by running some sort of SQL query or a small program that reads the image name in and rewrites it with the prefix.

Thanks in advance

DigiBooks:

Okay guys ... I did say at the start that I would need your hep from time to time initially so I'm hoping someone here can help me please.

I have successfully converted the OSC Products to ZenCart. As I mentioned earlier OSC does not allow you to pick and choose where you want to store images. So I have Author images and Book Covers which I want to store in 2 separate folders.

I did a test to upload a new author image for an exiting author and find that in the database instead of it showing "James Patterson.jpg" it now shows "authors/James Patterson.jpg" ... perfect!

I am not brilliant with MySQL at this time ... so is there a simple way I can prefix every image with "authors/"? Either by running some sort of SQL query or a small program that reads the image name in and rewrites it with the prefix.

Thanks in advance

Maybe you could use easy populate 4 for this. The module creates a csv file which can be edited in something like excel.

Fabulous .. will take a look because there are a few other things I need to change in bulk.

I assume just download the products file, empty the table and reload the csv?

DigiBooks:

Fabulous .. will take a look because there are a few other things I need to change in bulk.

I assume just download the products file, empty the table and reload the csv?

That could be one way. The other is to assign a model # to every item prior to download (there's a sql query a few pages back from the end I think) that will assign a unique model number if you haven't prepopulated your database with one.

The only issue though that I see with dumping the product table is that there may be information in other tables related to that (products_description, categories_to_products, etc.) That may become orphaned if done that way.

Forgot to mention, no prob, it's a pleasure to help those that help themselves and just need a little guidance to get where they want/need.

Thanks again guys. I found an SQL Update command to change every value in one field from zero to 1 so looking to see if there is and append string command that might work :)

DigiBooks:

Thanks again guys. I found an SQL Update command to change every value in one field from zero to 1 so looking to see if there is and append string command that might work :)

So your looking for the concat() operator. Wanting to update the filename's field to the value of Concat('authors/',field_containing_image_name). (Not sure you need a where clause, but still some homework to be done from the above statement. I didn't know off top of my head the names to be filled in.

Yes the field is manufacturers_image i table manufacturers and all I want to do is add "authors/" as a prefix to whatever the jpg filename is

DigiBooks:

Yes the field is manufacturers_image i table manufacturers and all I want to do is add "authors/" as a prefix to whatever the jpg filename is

Update manufacturers set manufacturers_image=concat('authors/',manufacturers_image);

Backup database before attempting, this is untested. Also, any existing manufacturer's records will be modified as well, so if there are a lot of such existing records that have been modified would want to some how group them that can be used with the above SQL command that is to be run in the admin's install SQL patches.

mc12345678:

Update manufacturers set manufacturers_image=concat('authors/',manufacturers_image);

> 
> Backup database before attempting, this is untested. Also, any existing manufacturer's records will be modified as well, so if there are a lot of such existing records that have been modified would want to some how group them that can be used with the above SQL command that is to be run in the admin's install SQL patches.

You're a star - that worked -thanks!
It has highlighted a problem though which is down to the way that I run the site. By adding this author path in then yes the author's image appears in the manufacturers info sidebox when you click on a book which is by that author.  The author image does not appear though when you select a genre (category) as all the authors are in fact used as a category with any series being sub-categories beneath that.

So my structure is Genre ==> Author ==> Series.

Having said that it is not really such a problem as I found that on the current live site a category such as Thriller has so many author images as to make it look really messy so I found an addon that enabled me to switch off the images and just have text links based on the authors' names.  If I can't find a similar addon here then I can always manually edit the templates to drop the author (category) images.

On the plus side, if I now do the same update for the books covers (product images) they do look in the right folder so at the end of the day I will be able to split my author and book cover images successfully.

Really strange thing now. I am going to the attributes controller to check download links and getting a red message saying product is disabled. In fact can only see authors and series in the drop down list so I'm guessing the conversion didn't work properly. I will restore the database to pre conversion and see if I can add products singly and get to the attributes. Beginning to look as though I may have a lot of work on my hands moving the data Lol

Now another really oddball thing... Got to work and logged into Testbed admin OK. Went to the Testbed shop and clicked to add a book to cart and get a 500 error - cannot display page.

Went to what will be the new live site OK ... no books yet. Went to the admin for this site and that returns a 500 error!!!!!!

Not sure if it is my sites or whether it is the works internet connection!!!!

DigiBooks:

Now another really oddball thing... Got to work and logged into Testbed admin OK. Went to the Testbed shop and clicked to add a book to cart and get a 500 error - cannot display page.

Went to what will be the new live site OK ... no books yet. Went to the admin for this site and that returns a 500 error!!!!!!

Not sure if it is my sites or whether it is the works internet connection!!!!

Just had it tested from another location and it seems both sites have collapsed yet I haven't touched the new 'live' site yet .... I am going to have to reinstall both from scratch and do a walk-through stage at a time!

DigiBooks:

Just had it tested from another location and it seems both sites have collapsed yet I haven't touched the new 'live' site yet .... I am going to have to reinstall both from scratch and do a walk-through stage at a time!

Just checked the error logs and it seems the whole of the includes/init_includes folder on the 'live' site had been deleted!!!!!!!!! This is quite quite worrying.

On the Testbed the error logs are referring to an addon which I installed yesterday so there is obviously a problem there.

DigiBooks:

Really strange thing now. I am going to the attributes controller to check download links and getting a red message saying product is disabled. In fact can only see authors and series in the drop down list so I'm guessing the conversion didn't work properly. I will restore the database to pre conversion and see if I can add products singly and get to the attributes. Beginning to look as though I may have a lot of work on my hands moving the data Lol

If not mistaken the product in the attributes controller is considered disabled if the file is not present where it is reported toneed to be (another one of those path issues). The file needs to be uploaded via ftp to the location identified in the attributes controller or the attributes controller updated to refelct where the file is/will be. This too can be modified (updated) with a Sql statement similar to what was provided before, but have to identify the table. Easy Populate version 4 is still something that can help with these mass edits. And my be of benefit moving forward once you have also corrected the file problems that are identified in the posts that will/do appear above this one.

mc12345678:

If not mistaken the product in the attributes controller is considered disabled if the file is not present where it is reported toneed to be (another one of those path issues). The file needs to be uploaded via ftp to the location identified in the attributes controller or the attributes controller updated to refelct where the file is/will be. This too can be modified (updated) with a Sql statement similar to what was provided before, but have to identify the table. Easy Populate version 4 is still something that can help with these mass edits. And my be of benefit moving forward once you have also corrected the file problems that are identified in the posts that will/do appear above this one.

Hi

I came to that same conclusion mulling it over and over. Unfortunately it is not the case. I reinstalled the clean database whihc has one test product 3 levels deep Thriller -> Dean Koontz -> Odd Thomas Series -> Odd Thomas #1

I then set the download file to a name which is not in the downloads folder. Quite rightly there is a red circle against this name in attributes because the file does not exist. However when I go to the Attributes Controller I can see the drop-down for the three levels but there is no *Product is Disabled message!

This message only happens after I imort all the current data from OSC - I checked the database in PHP Admin and every product has 1 set in the Product_Status field. Very odd!