Guest Posted January 19, 2004 Share Posted January 19, 2004 Hi, I'm designing an e-commerce site but the default catalog structure is not convenient for my client's needs and he rejected it. So I created a MySQL catalog (with all product info on 1 table) and I now have to integrate it to osCommerce. I should also mention that products are now described in only 1 language although the interface sould remain bilingual. On the other hands, some tools will be ignored and not used by my client, like advertising banners and newsletters. A problem with osCommerce is that its own catalog is split on several tables and, on a general basis, osCommerce is full of dependencies. Did some of you already replace the original catalog and, if so, are there a few things I should specifically bring much care to? I'm asking the question here to avoid wasting hours or days of research by myself, if some of you already experienced that... Thanks in advance. Link to comment Share on other sites More sharing options...
Guest Posted July 19, 2004 Share Posted July 19, 2004 Did you ever get this figured out? It has been several months since this post. I am having the same problems working out an effective database. We sell products based on available dates. (Vacation packages). Even adding or displaying a product is a nightmare. For instance, a hotel booking can be made by room type (single, double, double use, triple and quad) all of which have a different pricing structure. This pricing structure is further modified by the dates the room is booked as there are pricing differences for 3 different seasons, weekends and in some cases "Fair Days" which are used during local events. As a single room can have over 25 separate date ranges it will be necessary for the visitor to search for the product using a calendar or set of drop down date fields and I have no idea on how to set this up. Any help would be really appreciated Link to comment Share on other sites More sharing options...
Guest Posted July 19, 2004 Share Posted July 19, 2004 Hello, After analyzing the structure of osCommerce (which I still didn't manage to clearly figure out all internal relationships), I concluded that it was better to work out existing material, rather than intgrating external stuff (very risky). In order to satisfy the needs of my client, I added some fields to existing tables, and created two more tables. For the database administration, I designed a new interface with my own PHP scripts, totally independant from osCommerce' built-in admin tool. It works fine. There is only one thing you must consider : if you add variables associated to specific fields, they must be specified in the "configuration" table (just add them). Good luck! Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.