Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Extra Product Fields, Alias Records, Custom Zones


jsteele12

Recommended Posts

Hello everyone,

 

I posted a similiar message in General on Jan 24th and never received a reply, so I guess I put it in the wrong place

 

Product Fields

I've seen the contribution to add extra fields to an "additional" table, but I'd like to put them into the products table directly.

 

As I'm sure I'm not the first to go through this, I was wondering if anyone has a steps needed write-up anywhere. I've looked at the knowledge base, but no luck there.

 

I have about 20 new SELECT fields that I need to add to the admin side (admin/categories.php?), that I will probably store these option values in another table, like the following:

 

class = 'Albas', 'Bourbons', 'Chinas', ...

avail = 'In Stock', 'Out of Stock', 'Jan', 'Feb', ...

bloom_size = '.5', '1', '1.5', '2', ...

color = 'Apricot', 'Blush', 'Gold', ...

growth = 'Arching', 'Spreading', 'Upright', ...

 

And of course I need to display the added fields values in the product display with appropriate dropdowns in the advanced search.

 

Any pointers to generalizing this type of a solution would be great. I'd probably like to eventually make this a contribution with a tie into Easy Populate.

 

Alias Records

I need to add 'alias' records (or Also Know As) records that won't allow adding to cart but take you to the 'main' record. I assume I'd need another table to join with for an alphabetical listing page.

 

Pricing Structure

I think this can be done with product attributes, but I'm hoping there might be a simpler way. Bands, 1 gallon, 2 gallon, 5 gallon all with different prices and weight (see shipping zones below).

 

Custom Zones

This looks like a mess to try and implement, any ideas would be very appreciated (see near bottom of this page).

Shipping Table Page They don't want to use FedEx default shipping by weight (sigh).

 

Thanks in advance for ANY pointers,

John

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...