Looking to migrate to ZenCart from OSC

Design75:

Good morning, good to see you feel better.

Wouldn't say better ... just an awake day! ...so 5 more days for results and maybe the GP's will get their backsides back into gear!

I thought I had nearly finished all the changes just to get a basic system up and running then found shed loads more files to amend! The standard output from ZC doesn't match what we do ... but I'm getting there.

Once I get to the stage where I can transfer the OSC data across and rejig all that then I can start working on the niceties.

DigiBooks:

Think I may have rethink this LOL!

Ok Ok ... I'm gonna grab some sleep (that's all I've done for the past 7 weeks since the Docs started experimenting because B12 tablets make me really ill (and cost shed loads) and they need to get me back onto injections that the bloody State can pay for!) .... I'll let you know when I need to feel worthless again ... thanks :)

Totally off topic: Not surprising the B12 tabs are not doing anything (if they need to be swallowed..)

pls check your PM

Cheers / Frank

frank18:

Totally off topic: Not surprising the B12 tabs are not doing anything (if they need to be swallowed..)

pls check your PM

Cheers / Frank

Thank you Frank :)

I will drop you an email shortly explaining all

Regards
Alan

OMG!!! I think I am now ready to start the data transfer from OSCommerce (yuk!) to Zencart :D

OK there are a couple of backward steps from what I currently run but these can be progressed once the new website is up and running (and yes I probably will come back here and ask some stupid questions!!!!)

This has been a real experience and I could not have done it without you guys out there spinning me round and sending me off in the right direction when I got stuck. Thank you to everyone who has taken the time to respond to this thread and given me advice and ideas.

The next few days should hopefully see a revamped and fully working site .... now for the scary bit :shocking:

I succeeded in transferring all the OSC data across to Zencart last night and make all the necessary amendments in PHPMyAdmin.

We now have a handful of testers trying to see if they can break the system before we go live on 1st July :smile:

All is going well with the new site and we are carrying out a lot of data cleansing before the relaunch. Most of existing books have a piece of HTML code and text at the end of the book description advising that the download zip file contains both ePub and mobi formatted books. This piece of code is now redundant. Does anyone know of an SQL query method that can detect and remove this code or any other simple method? Thanks in advance

DigiBooks:

All is going well with the new site and we are carrying out a lot of data cleansing before the relaunch. Most of existing books have a piece of HTML code and text at the end of the book description advising that the download zip file contains both ePub and mobi formatted books. This piece of code is now redundant. Does anyone know of an SQL query method that can detect and remove this code or any other simple method? Thanks in advance

There's a REPLACE function that could be used for the data_field in question: REPLACE(text of data field, text to find, text to replace found text) which returns the resulting value.

So something like an update of the table setting the description field to the replac function where the description contains the desired search text.

The above is pseudo code for what you're looking for I think.

mc12345678:

There's a REPLACE function that could be used for the data_field in question: REPLACE(text of data field, text to find, text to replace found text) which returns the resulting value.

So something like an update of the table setting the description field to the replac function where the description contains the desired search text.

The above is pseudo code for what you're looking for I think.

That sounds promising. Will try it out on the test site. Thanks

Evening all.

Just a quick query ... we have 6269 books online on the soon to go live site. I have just noticed that in the central What's New in June box and the scrolling What's New sidebox that the last books added are not appearing in the list - the output seems pretty random across the database.

I've tried to locate a setting admin so that it does pick up what we've just added but cannot find anything.

Could somebody point me in the right direction please?

Thanks in advance

It is in configuration - maximum values

http://www.zen-cart.com/content.php?45-what-determines-if-a-product-is-new-%28new-products-for-xxxxx-month%29

Design75:

It is in configuration - maximum values

http://www.zen-cart.com/content.php?45-what-determines-if-a-product-is-new-%28new-products-for-xxxxx-month%29

How the hell did I miss that????? Only problem is I set it to current month and the last book I added did NOT appear lol. Tried 7 days ... still did not appear!

It's based on products_date_added in the database. So, depends what you've got set on that field for those products. The system automatically sets it to "today" when you're using the Admin to add products. But if you add them some other way, then you may have to take care of that part manually.

DrByte:

It's based on products_date_added in the database. So, depends what you've got set on that field for those products. The system automatically sets it to "today" when you're using the Admin to add products. But if you add them some other way, then you may have to take care of that part manually.

Yes I get that and (sorry) OSC added the latest today books ... I added a book through the ZC admin today yet it does not appear in New Books for June so a bit confused

The book has this:

This book was added to our library on Thursday 26 June, 2014.

In the central New Books for June there are 9 books and not one of those is this book

Configuration->Maximum Values->New Products Module (default: 9). The New Products centerbox displays a random collection of 9 by default.

DigiBooks:

The book has this:

This book was added to our library on Thursday 26 June, 2014.

In the central New Books for June there are 9 books and not one of those is this book

All being equal that book should show in the listing of yoursite.com/index.php?main_page=products_new .

Two things to mind, while this "newest book does not appear to be "making the cut" to display in the nine random spaces, does those that do appear fit the desired criteria and as memory serves is the date added correct for those items?

The other thing that comes to mind was that I thought there was an option in the new product listing configuration menu as to which category to assign items. (I should check before posting, but don't want to lose what I've written so far while trying to investigate). Maybe I'm thinking of the featured listings, but at any rate, if there is such an option in the applicable menu, the expectation would be that in the products to categories table an entry would exist for that product to that category, and when it no longer applies, then it would get removed from that category (or manually could be added/removed).

Thanks guys ... tied up in tomorrow's relaunch so will check this out shortly .. and Frank ... got your email and will respond once we're live )

DigiBooks:

.. and Frank ... got your email and will respond once we're live )

No rush!

Hi all

The relaunch went amazingly and all is running well on Zencart :smile:

We are now carrying out some tidy-ups and I have a small problem.

I am trying to increase the display of an image (Category -> sub-category -> subcategory .. tried every setting I can see but nothing changes it.

the image and breadcrumbs can be seen here:

http://digibooks.org.uk/DB_Library_2014/index.php?main_page=index&cPath=36_659_1164