Monthly Archives: September 2008

Easy Populate (EP) Wizard Feedback

For tutorial on how to use Easy Populate Wizard, read Easy Populate Wizard Tutorial

easy-populate-wizard

Please post your EP (Easy Populate) Wizard, feature requests, commet, and feedback here. Also you can request a free copy of Easy Populate Wizard for 15 days trial at no charge.

Read Easy Populate in a Weekend

Easy Populate (EP) Wizard

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

 

 

 

 

Magento Installation Preamble

The very first time I tried to download Magento, I was a little bit confused because I didn’t know if I should download the downloader or the full release.

The downloader contains fewer files; it automatically download the rest of the files during installation. The full release as the name implies contains all the files needed for installation. Note that sample data is not included in full release. For my installation I downloaded the full release version.

Time Zone Offset – Adjust to match your location

I have just installed Time Zone Offset contribution. Installation instruction is clear except I couldn’t immediately find the correct putenv timezone argument for my location. To locate my timezone I find these two links very useful.
List of Supported Timezones
Standard time zones of the world as of June 2008

timezone

timezone

 Changes recommended in this thread Time Zone Offset – Adjust to match your location, Needs a little work to be complete.. is not necessary.

MySQL Error: 1046 – No Database Selected

Among other things, if you are getting this error, make sure to add “user” to your “database” through your cpanel. It is very easy to forget this steps, espeially if you are going through this configuration for the first time.

Select your choice of user and database then click the Add button to process your selections.

Step to add user

Next you will see the privilege selection screen. Selection your options or select ALL.

privilege selection

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

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.