Definitions: Wholesaler: the “mother” site that the reseller sites are based on Resellers: one ore multiple reselling sites that have the same products the wholesaler does, but they are marked up a certain percentage or set amount. What is currently done: There is currently a wholesaler site ready to go, it is a base install pretty much of cre loaded oscommerce. This site will need to be copied to a reseller account and the following specifications used. In the future, it needs to be possible to copy this reseller site to other reseller sites using the same database script that will be created for this project. Site Specifications 1. resellers products prices and description are updated automatically when the main wholesale site is updated 2. resellers have the ability to chose which products and categories they want to resell 3. resellers have the ability to add their own products 4. resellers can adjust the product descriptions and prices to their liking 5. resellers can set a markup percentage or a set markup price 6. resellers can set their own S/H module and payment 7. resellers have the ability to change their own site templates 8. Main wholesale site has admin to setup additional stores Method Used To Accomplish Database Updates (up for suggestions) To be accomplished by a script that updates the resellers database twice a day using a cron job. The wholesaler and reseller sites databases will be kept separate. This script will: - Update prices and descriptions of wholesaler products in the reseller database - Add new products and product categories to the reseller database that the wholesaler has added (as well as product attributes tied to the products – maybe?) - Delete products that the wholesaler no longer is selling, deactivate them, and adjust stock levels Database will probably need to distinguish between products and product categories the reseller adds vs. ones the wholesaler adds. For example: products the reseller adds that are tied to a wholesaler product should be marked as such in their product id, perhaps w_001 where w represents w for wholesale product. Products the reseller adds separate from the wholesaler can be marked r_001. Admin - Catalog - Products Resellers: Needs percentage markup option and set price markup option for each product and product category (option to override product category markup) Needs option in product categories that are tied to wholesaler site to sell these products or not sell them, same for each individual product Needs option to allow reseller to change the product title to what they want, the description, and the individual shipping price if there is one. Still store the reseller description, title, and individual shipping price though (this could probably be accomplished by making a new “language” and just calling it “reseller language” – just an idea) Notes: s/h module and payment module don't really need any changes since the reseller site will use a separate database.
Hi! Pls check PMB for details. Thanks. Gus.