For an average e-commerce site, managing product quantity prices for different customer groups can be a daunting task. If you look at it closely, for 10 different prices and three different customer groups, that translate to 30 different values to update. Now multiply that by 200 
different products, that is 6000 different values to update. Even with the aid of easy populate, it does not in any way reduce the volume of work that needs to be done.
In the spirit of continuous improvement, there is a solution that eliminates this problem. What the solution does is provide the capability to set the base price and end price for each product. By using a linear relationship, 
the individual prices for each price points can be calculated on the fly there by eliminating manual intervention.
Another advantage of this method is the ability to use it with easy populate effectively. There is no need to replicate rows to accommodate the different customer groups.
By admin
|
Posted in CRE Loaded, Easy Populate, Productivity Tool, Zen Cart, data manager, osCommerce
|
Tagged CRE Loaded, data manager, epa, EPB, osCommerce, Productivity Tool, QPBPP, SPPC, Zen Cart|
I recently came across this problem; may be it’s not really a problem but it is something worth noting. While importing an EPA file, EPA import will just hang up and display a blank screen. I noticed that the EPA file is actually imported but only up to some point, the first 78 rows to be specific. This implies the code broke on row 79. I didn’t understand the problem immediately because I compared row 78 with row 79; both look similar to me. After a while I decided to remove row 79 and re-import again. To my surprise everything worked fine! Later, after extensive research on the culprit row 79, I finally realized that the problem was due to:
v_products_model
The specified length is 25 characters, but in my offending row, the length was 26. So for this particular row to be imported, I had to alter the number of characters in my products model number to be 25 or less.
If you really need more than 25 characters for product model; go to epconfigure.php (located in admin folder), change:
$modelsize = 25;
to a number of your choice then go to your products table and change
products_model
to the same number.
different products, that is 6000 different values to update. Even with the aid of easy populate, it does not in any way reduce the volume of work that needs to be done.
the individual prices for each price points can be calculated on the fly there by eliminating manual intervention.