Easy Populate (EP) Wizard

By admin on September 21, 2008

STEP – 1 SELECT EP type corresponding to the one you use for your store.

EPA – Easy Populate Advanced comes with cre loaded. Product identification based on product id.

EPB – Easy Populate Basic – http://www.oscommerce.com/community/contributions,500. Product identification based on product model. A variant of this comes with cre loaded as well.

Easy Populate Wizard Step 1

Easy Populate Wizard Step 1

 

STEP – 2  Here you provide information about source file

  1. Field Delimiter 

    possible selections in this drop down are asterisks(*), caret(^), comma(,), dash(-), pipe(|), semi colon(;), space(\s), tab(\t), tilde(~). Default is tab(\t)

  2. Source File Name

    Use the “select” button to bring out file dialog window

  3. First Row Contains Column Headings

      Check this checkbox if the first row of the data/source file contains column headings

  4. Reference Column

    Use this to select the column you will like to fix and use as reference for navigational purposes.

easy populate wizard step 2

easy populate wizard step 2a

Easy Populate Wizard 2b

Easy Populate Wizard Step 2b

 

STEP 3 Here you provide information about destination file that is the you want to save your processed data as.

1. Field Delimeter drop down for selecting the type of delimiter to use. The default and recommended delimiter is the tab (\t). Possible values as asterisks(*), caret(^), comma(,), dash(-), pipe(|), semi colon(;), space(\s), tab(\t), tilde(~).

2. EPA or EPB File Name to use.    

Easy Populate Wizard Step 3

Easy Populate Wizard Step 3a

Easy Populate Step 3b

Easy Populate Wizard Step 3b

STEP 4 This is the final step. Here you are provided with EPA or EPB dedpending on your selection in step 1.

1. Source File Fields provides source file fields in drop downs. Your objective is to select fields in the drop down that you want to match to the corresponding EPA or EPB fields.
2. You have the ability yo override these values using the Override Default Value input boxes.
3. When you do not need a field, select exclude this field. 

 

Easy Populate Wizard 4a

Easy Populate Wizard Step 4a

Easy Populate Wizard 4b

Easy Populate Wizard Step 4b

 

More on easy populate and easy populate help

Bookmark and Share

Posted in , , , , Tagged , , , , , Leave a Comment

Custom Quantity Pricing (custom quantity price breaks per product) with Customer Groups

By admin on September 13, 2008

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 Quantity Price Breaks with Customer Groupsdifferent 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, graphical illustration of price point calculationthe 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.

More on easy populate and easy populate help

Bookmark and Share

Posted in , , , , , Tagged , , , , , , , , Leave a Comment