Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Product Price Quote System


Turv

Recommended Posts

Posted

Well, Here's my situation, Certain products on the website have the availability to have 'Engraving' one them, but because of this process the price is never fixed, as they vary from job to job, and therefore they must get a price quote to purchase this.

 

The Idea

 

On the Products page, There will be a button to 'Request a quote' This will display a form for them to fill in, including the product information, and what they want doing with the engraving, text etc etc.

 

This will forward onto the Store owner, where they can put together a price quote, and get in contact with the customer.

 

What i want, is for the Store owner to 'generate' a Quote Number which they can pass onto the customer, and there will be an area on the store where they can enter this quote number, Upon doing this it will bring up the item they wanted to originally purchase, However it will have the quoted price, instead of the standard selling price without the Engraving.

 

What it would require

 

A Contact form to submit the Engraving information (Already implemented)

An area in the Admin panel for a Quote to be 'Generated' including the quoted price.

The ability for the customer to enter the Quote Number and purchase the item at the quoted price.

 

 

Now, I am asking here for advice on how to go about doing this, Set up a database table to store the quotes?, My problem is im not familiar with the workings of the payment system, and as such i am unsure how i would 'Generate' the order from the information from the database into an actual product to be able to purchase.

 

I've seen the Order Generating tool in the contributions, but this will only Edit an order once it has been processed, If it has been processed though, how do you edit the prices before the credit card transaction completes?

 

Any help, advice is appreciated, or if you can recommend a better method than above.

Posted

Just an update, I have begun work on this myself.

 

Tasks,

Customer: Get a Quote!

This fills in a contact form and submits it to the store owner

 

Admin Panel: Raise a Quote

Select Product (Engraving product), price, quantity, and quote number - Insert into a database table

 

Shopping Cart: Enter Quote Number

Customer enters quote number provided, Item is added to shopping cart ready to purchase

 

Add to Product to Shopping Cart

Product information is pulled from the Quotes table in the database using the quote number, This product is then added to the customers_basket table where it will appear in there shopping cart ready to purchase.

 

I have already implemented the area where the customer enters a quote, and the product is automatically added to the shopping cart, However it uses the price that is set in the database, What i want it to do is use the price that i have set in the Quotes table, This price is unique to the quote, not to the product.

 

Anyone have any idea how i can change the price of a product before completing the transaction?

 

The Quote Ref number is a 5 digit string, generated automatically stripped from an MD5 Hash.

Posted

Okay, Worked on it more throughout the day, and came to the conclusion instead of trying to change the price of the product.

 

Have the customer add the product they want engraving adding onto, Fixed price. then in the Shopping Cart enter the Quote reference number as above, But instead it just adds the additional fee (Quote Price - Cost of product).

 

So it works in the same was as a Delivery Charge, or the opposite of the 'Discount Codes', Enter the code but instead of taking money off, it adds a set amount pulled from the database pulled from the final price.

 

What i want to know is, Is it possible to once you enter this quote number to display this 'Addiitonal Fee' in the shopping cart, before getting to the Checkout?

Posted

Thanks for your effort on this so far. I am in need of something similar...I'll do my best to explain below. Maybe this solution would work for us or there's a better way to go about it.

 

1. A majority of items in the catalog will not or cannot have published prices in the cart. These items need to go out for a quote and based on who the customer is (vendor, end-user, reseller) and how much they are buying the prices can differ. It is not even necessary to re-issue the prices to them from oscommerce or have the purchase go through the shopping cart as we can issue the quote and payment through another billing system that is established. The main thing we'd like to have is for them to select the items they want a quote on and have those stored for our and their reference and receive an email notification that a quote needs to be issued. Our sales staff can then take over from there.

 

I think what may make this complicated is that some items will have prices and can be purchased. So, what happens to an order that contains both priced items and "out for quote" items? I'd be fine with it going to a pending status similar to a back-order hang up or something similar.

 

2. A form as mentioned in your engraving scenario would be advantageous as well - not sure if I'd need it for each item but maybe one form for the entire order where the shopper could list details, application, timeline, etc.

 

3. If it makes it easier, I'd could even deal with the entire cart being "out for quote". For the products that do have prices I could sell them on a separate system or just require they go out for a quote also as they're in the minority.

 

Any thoughts would be great. Thanks in advance for your help or suggestions!

Archived

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

×
×
  • Create New...