Project for today was to build a system to allow a shopowner to assign a leadtime to products. For example, a hand made product that takes 3 days to produce. Now imagine shopowner sells 50 or 60 such products, some of which can be sent immediately, some take 3 days to produce, some take 5 days. Or another scenario is if shopowner has a supplier who takes a little time to get products to him to resend to customer…you get the idea, I’m sure.
So, shopowner can now set up individual products to have a “lead time” in days;
Of course, products could all have the same amount of lead time, or could have different amounts. I then made logic that grabs the value (in days) of the product being purchased that has the highest leadtime and works out the next available working day based on this;
In this example you can see the matrox has a lead time of 5 days, and the printer has a lead time of 1 day. The message underneath takes the higher amount of days and works out 5 working days from order date. Saturdays and Sundays are not counted as working days, and I have also added the ability for the shopowner to add in bank holidays, vacation time and so on.
In the checkout process, I also show a similar message;
A good way for shopowner to let customers know that some products are not available immediately!
For those people who do not want to tak the chance of upgrading their shop(s), I install the new password reset functionality, and fully test it. It does not matter if your site is modified by addons or templates – I guarantee a fully working upgrade of the password functionality.
The service is going to be a “beer fee” of £20 per osCommerce install, payable by Paypal. If interested, email me on oscshops AT gmail DOT com
Please bear in mind that I require FTP access to your existing 2.3.1 shop, also that I will create an account at your shop (to test the new functionality). If your site runs multiple languages, you will need to translate for me.
Earlier in the year I created a “products to specifications” system – it was created specifically for a Pet Shop where the site owner can say “this product is good for Rabbits, Guinea Pigs, hamsters” and so on. This can be done for an unlimited number of specifications on an unlimited number of products. So, 1 product is great for this and this, another is great for this and that, another is great for that and that. You get the idea, I’m sure. The Admin Area looks like this (product adding/editing page);
Fast forward 6 months, and it is now time to do another portion of the Specifications project. This portion is to allow the customers of the shop to tell the Shop Owner what animals they own. Once coded it will look something like this;
The available animals are the exact same as in the admin area. When the Shop Owner adds or removes animals, these options update. The Customer ticks the animals they have and this data is saved in a new Database table. When they acquire a new animal, they can easily update in the customer_account page.
What is the reason for knowing the animals a customer has? Anyone have any idea(s)?
Late last night I came across an interesting post from Carine, where the need is for filtering and sorting of the special offers. I’m intrigued to see what Carine comes up with…
In the meantime, I decided to code up something very quick and dirty on the specials page only. I chose the easiest options and came up with a way to filter on;
– % of the discount
and sort on;
– amount of the discount
In addition I wanted to ensure that selected sort/filter is maintained even if another sort/filter is chosen. In this way I can say (for example) “show me discounts above 25% on products by Microsoft, sorted from high to low”. This makes the specials very easy to find, and would be useful for those shops who have many special offers running at one time.
There’s no limit to how many filters/sorts can be run at one time, as all the filters/sorts do is change the SQL command that grabs the products from the database.
Here’s an example video, showing some sorting and filtering;
Some more examples (would just need a link added, and some extra SQL);
– filter specials to show all DVDs on special offer
– filter specials to show all DVDs only from Warner that are more than 50% discounted
– sort specials by original price
I’m sure that we can think of many more. And all are possible, why not?
A good idea by Carine, and useful for allow potential clients to drill down through your special offers to find what they are looking for faster. Which can only be a good thing.
The other day I wrote about my new “fuzzy search” which brings more power to the search function of osCommerce. My friend Paul asked about having a “contact form” on the search results page. My idea was to have a form show if the fuzzy search results show.
So, now the advanced_search_result.php page looks something like this;
Now the person searching has the ability to see “exact matches” as per usual osCommerce and “fuzzy matches” as per my update and a “form” to easily contact the Shop Owner. The form utilises the usual osCommerce structure, including error messages as appropriate and action_recorder.