Help in setting up OSCommerce store in canada

[grossd]

Hello,

 

We are starting a business and I would like to set up an OS-Commerce store selling a few products online. Part of the requirement is to set up a purchase codes system. We would give out such purchase codes to individual distributors, who would use them when placing orders for their customers. Distributors could also publicize on marketing material their purchase codes in their respective geographic areas, so that customers can enter them when placing orders. Purchase codes help us determine for each order who receives the comission, and how much the comission is.

 

Currently we have one product, that comes in two versions. Version 1 has an additional option, and version 2 has two additional options. In the future we may want to support customers in uploading graphic files, which we would use to produce one of these options.

 

I am looking for someone in Canada who could help me set up OS commerce to support such a system. Preferrabily i would also want to find someone who with whom i could then host the system.

 

 

appreciating a response,

 

Daniel

[Guest]

The first part should be fairly simple to implement. I think you would need 2 additional tables. One for the distributor details and another to define the relationship. customers_to_distributors

Then the customers table (or customers_info) could be extended by an extra column to accomodate the reference id. The admin side would require the control of the distributors table much like you have for the products or countries etc. On the catalog side you add an extra custom field when a customer creates an account for the reference id of the distributor.

 

The 2nd part is more complicated for the upload because you'll have to change the product attributes on the catalog side, during uploading. Perhaps that should first be approved by the admin section before allowing the extra options to propagate to other visitors/customers.

 

For the 3rd part there are a lot of discussions in next steps marketing forum, many hosts have good offers from time to time to host an osc store.