0

Search Translation Mapping

We have set up a custom search and have added a ‘translation’ mapping feature that allows you to map search terms with pre-set attributes to which products are assigned.

To ‘map’ is a computer / maths term to associate one element with another.  In this case you want to associate a ‘search word’ – say for example ‘a4 paper’ with a set ‘attribute’ – say ‘photo papers’ attributes.  So when someone types in ‘a4 paper’ in the search bar, the suggested attribute ‘photo paper’ will display.  In this way, you be very precise and customise the search results for customers.

To find the ‘translation mapping section, it is in the main menu of the website – go to ‘translation mapping’.

There are several things you can do here:

  1. View existing translations
  2. Add, manually, a translation
  3. Bulk import translations
  4. Edit existing translations

SEQUENCE

Lets add a translation manually and by CSV.

The first thing is to ensure that attribute exists.  There are a lot already uploaded, but if you are doing a new line of products, it’s worth checking.  Go to ‘CATALOG > ATTRIBUTES > MANAGE ATTRIBUTES and find the ‘narrow by product type’ attribute.

Click on the attribute and see if you relevant attribute is set up or not, and add it if required.

Download below sample csv file I have prepared.  Please note there are just two columns required:

Find-word

Target

The ‘find word’ is the new search word you are setting up

The ‘Target’ is the existing (already set up) ‘search attribute’

Download Sample CSV

Now lets set up the hypothetical case where we want ‘photo paper’ attribute to show up if I type in ‘a4 paper’

We would on the ‘find-word’ column enter ‘a4 paper’ and in the target column ‘photo papers’.

Add any others you want to import, go to the import dropdown, select your file and click on the ‘import’ button.

Please note, upload only new translations as existing translations will be duplicated.  It will not cause an error on the frontend but otherwise you could end up with lots of duplicate entries in the backend.

Any questions, please post a comment below.

 

0

Importing to the Product Finder

The product finder allows a customer to quickly search for their compatible part based on the brand / model the customer has.

For example selling Printer Cartridges, there are original and compatible ones available and by assigning which cartridges go with what brands, it allows the customer to simply select what printer and model number they have in order for the customer to find compatible cartridges.

Unlike product imports, the product finder importer is looking for the columns to be in a specific sequence, and if not in the correct order, it will error.

The sequence depends on the original set up – the best way to view it is to download either of the attached sample csv’s.

PRINTER CARTRIDGE FINDER

Download Sample CSV

TILLROLL FINDER

Download Sample CSV

SEQUENCE

  1. Ensure that the SKU is in the catalog – ie the product exists in your Magento store.
  2. Prepare your CSV file
  3. Go to the set up ‘part finder’ profile by navigating to catalog > part finder….
  4. Click on the ‘import’ button on the top right:
  5. Import the csv file.

Any errors you encounter are usually down to two reasons:

  1. Columns are in the wrong order or you are missing a column
  2. One or several products are not yet set up in the Magento catalog.

Any questions, let me know in the comments section 🙂

0

Uploading Multiple Images to One Product in Bulk via CSV- Magento 1

When you have already identified your main product image, you can also upload additional ones:

You’ll need two columns headed by:

sku

images

Again there is one cell that will have the SKU defined and in the cell next to it, the images defined.  Each additional image is separated by a comma.  Please note to add a forward slash at the beginning of each image /.

So a cell would look like this (the ” automatically added to the cell – don’t add this manually)

“/2nd-image.jpg,/3rd-image.jpg”

Images should FIRST go into the /media/import folder via FTP.  This is accessed via PUBLIC_HTML / MEDIA / IMPORT.

Once you have your csv ready and uploaded your images to the import folder, in the Magento backend, navigate to SYSTEM > IMPORT/EXPORT > FAST BULK PRODUCT IMPORT > DATAFLOW – PROFILES

Select the import profile:

And run the profile:

DOWNLOAD SAMPLE CSV

0

Adding Tiered Prices in Bulk via CSV – Magento 1

When uploading tiered prices to products, you need to have just two columns (for existing products):

sku

tier_pricing

Enter your SKU in the first column and in the following cell, in the same row, add the tiered price.  All the data for all the tiers are entered in on one CELL.  Each cell contents is delimited by quotation marks “, each tier is defined by the pipe symbol | and each element within each tier is separated by commas.

So within each tiered pricing cell the following data is required to define ONE of the tiers:

“Customer Group Name,Website Code,Qty,Price”

A note regarding group names – if you want to upload to ALL customer groups rather than a specific customer group, please use ‘all’ text for the customer group name. If you use ALL GROUPS your import will fail.

If you download the attached CSV, you’ll see a sample of workable data to import.  Any questions, let me know.

Once you have your csv ready and uploaded your images to the import folder, in the Magento backend, navigate to SYSTEM > IMPORT/EXPORT > FAST BULK PRODUCT IMPORT > DATAFLOW – PROFILES

Select the import profile:

And run the profile:

Download Sample CSV

0

Enabling / Disabling Products in Bulk – Magento 1

There are two ways to easily enable / disable products in bulk in Magento 1.

The first is to go to CATALOG > PRODUCTS, mark off on the left hand side which products you want to disable, then on the actions dropdown (top right of the table) check on ‘change status’ and then a new dropdown will appear – status – which you need to set to ENABLED or DISABLED – depending whether you want to enable or disable your products.

For more than just a few select products, it’s much better to use the CSV import option.  Prepare a csv file with two columns headed by sku and status (please note – case sensitive).

Enter the SKU on one cell and next to it in the next cell (same row) enter 1 for ENABLED or 2 for DISABLED.  Once you import the csv file, any sku’s marked with 1 or 2 will be enabled/disabled respectively.

DOWNLOAD SAMPLE CSV

Now navigate to SYSTEM > IMPORT / EXPORT > FAST BULK PRODUCT IMPORT > IMPORT PROFILES and select

Click on RUN PROFILE in the top right hand side

Browse for your prepared CSV file, select it, ensuring there are no errors, and ‘RUN PROFILE’.

0

Change Prices in Bulk – Magento 1

Changing prices in bulk can be done through importing a CSV with two columns – headed by a ‘sku’ column and a ‘price’ column.  See below sample csv

DOWNLOAD SAMPLE CSV

For each existing SKU, set the new price and save your CSV file.

Once completed, go to SYSTEM > IMPORT/EXPORT > FAST BULK PRODUCT IMPORT > DATAFLOW – PROFILES

Click on the ‘update product prices’ profile:

Click on ‘run profile’ button – top right hand side of the page.

Now choose your CSV file and run the profile:

0

Deleting Products in Bulk in Magento 1

There are a number of ways of deleting products.

Please note that when you delete a product (rather than just disable it), you are completely removing it from the database and it will not be retrievable in the future.

If you only have a few to do, you can simply go to CATALOG > PRODUCTS, find and check off on the left-hand side the products you want to delete and then in the ‘actions’ dropdown find the ‘delete’ option and then click on ‘submit’ button.  This will delete these carefully selected products.

However if you have 100’s or 1000’s of products to delete, the handiest way is to create a csv file.  Name the header row ‘sku’ and below this list (one in each row) every SKU that needs deleting.

DOWNLOAD SAMPLE CSV

Once completed, save your CSV file to something you will remember and place somewhere on your computer that you can navigate to easily.

Now in the Magento admin area, navigate to SYSTEM > IMPORT / EXPORT > IMPORT.

Once in the import area, change the ‘import behaviour’ dropdown to ‘delete entries’, choose your file and then ‘check data’.  Once your data checks out okay, import the file.