Dealing With Slashes “/” in Magento Category Names

Recently I had a client that had a traditional html site where he sold his antiques, complete with html/cgi order form. 🙂 A client of mine suggested that he upgrade to an actual ecommerce site and gave him our information. A large number of his categories had slashes in the name, Artists/Prints, for example. 

So I needed to find a way deal with Magento’s understanding that a / denotes a category/subcategory assignment rather than it just being part of the category name.

I spent a fair amount of time researching on google and I found a few articles that talked about it, but no clear way to deal with it (enclosing the category names with quotes didn’t work and neither did escaping the character as some posts suggested) until this morning when it hit me.

Ascii html Characters! Could I substitute / with / and would that still display a / on the storefront, but be accepted by the store input? so i did a test and indeed it worked perfectly! I had already created a Import/Export profile for categories, so just deleted the categories that had a / in the name, edited the category csv file subbing in / for any / and uploaded. Then i uploaded a test product to Artists/Prints and it worked! So on the storefront i had Artists/Prints showing as a category and my test product in it.

So here are the steps I took and hopefully this helps anyone that’s run into this problem that doesn’t want to change their category names to remove their /’s all together.

  1. Manage Categories > replace / with /
    1. I had over 70 categories to deal with so it was easier to make a import/export profile http://www.templatemonster.com/help/magento-how-to-exportimport-data-in-csv-files.html#gref and edit using Find/Replace in excel/openoffice or you can download an extension to help you.
  2. Open your product spreadsheet, go to the Categories column, using Find/Replace to do the substitution.
  3. Import!

Hopefully this is helpful to you all!

Merry Christmas and Happy New Years to you all!

AdWords Conversion ROI Tracking for Bigcommerce Stores

If you place the default Adwords conversion roi tracking into your Bigcommerce store’s affiliate code section all you will get for your trouble is a count of your conversions. While this is helpful you will be missing out on a lot of good information. You will not know your Bigcommerce store’s ROI (return on investment), you will not be able to see what keywords are making you the most money.

Step 1:

Take this code:

<!-- Google Code for Purchase Conversion Page --> 
<script language="JavaScript" type="text/javascript"> 
<!-- 
var google_conversion_id = <strong>Your-Merchant-ID-Here</strong>;
var google_conversion_language = "en_US"; 
var google_conversion_format = "1"; 
var google_conversion_color = "666666"; 
if (%%ORDER_AMOUNT%%) {
var google_conversion_value = %%ORDER_AMOUNT%%;
} var google_conversion_label = "Purchase"; 
//--&gt; 
&lt;/script&gt; 
&lt;script language="JavaScript" src="http://www.googleadservices.com/pagead/conversion.js"&gt; 
&lt;/script&gt; 
&lt;noscript&gt; 
&lt;img height=1 width=1 border=0 src="http://www.googleadservices.com/pagead/conversion/Your-Merchant-ID-Here/?value=1&amp;label=Purchase&amp;script=0"&gt; 
&lt;/noscript&gt;

<span style="font-family: times new roman,times; font-size: 12pt;">Replace <strong>Your-Merchant-ID-Here </strong> with your Google Adwords merchant ID. </span>

<span style="font-family: times new roman,times; font-size: 12pt;">Step 2:</span>

<span style="font-family: times new roman,times; font-size: 14pt;">Bigcommerce control panel, click <b>Setup &amp; Tools</b> › <b>Customize your store</b> › <b>Conversions</b></span>
<img class="alignnone" src="http://s3.amazonaws.com/awesome_screenshot/6560566?AWSAccessKeyId=0R7FMW7AXRVCYMAPTPR2&amp;Expires=1416872685&amp;Signature=l%2FU73dm5sz5CYWb7nlWJmRDdPVg%3D" alt="" width="866" height="372" />

<span style="font-family: times new roman,times; font-size: 14pt;">Drop the edited code into the box on the next screen and click save. Give it a couple days to catch up and you should have new conversion data!

</span>

ProStores Shutting Down After 15 Years of Service

ProStores shutting down after 15 years of service, not something I thought I’d be saying after working with amazing ProStores merchants and members of the PS tech team and executive team . I can’t imagine this has been an easy decision, but its made now and there is no turning back.

From the prostores.com home page:

—————-

Dear ProStores Merchants,

We’ve made the difficult decision to shut down ProStores on February 1, 2015. Your store will not be affected during the Holiday shopping season – it will continue to operate and perform normally, and ProStores will continue to provide customer service until February 1, 2015.

Over the past 16 years we’ve had the opportunity to work with thousands of merchants and have been humbled to be a part of so many success stories. Going forward, we’re focusing our resources on eBay’s Magento Enterprise Edition and Magento Community Edition, two solutions that better support and better equip small and medium size merchants to prosper in the evolving and increasingly competitive eCommerce landscape.

Please be sure to take advantage of the checklists, planning resources and special offers found in the Migration Center to help smooth your transition to a new eCommerce solution.

Sincerely,

Mark Lavelle, SVP, Product and Strategy, eBay Enterprise

———————-

If you log into your admin you will see the new Migration Center which outlines what you can do to keep your store going and migrated to another platform like BigCommerce or Magento CE (not to be confused with Magento Go which is also shutting down).

There are some really great deals on migration, especially for the BigCommerce platform (which we recommend for probably 80%+ of ProStores merchants).

We are ready to work hand in hand with all ProStores Merchants, current clients, past clients and new to make this transition as smooth as possible.

Store Transfer and Migration from ProStores to BigCommerce, made easier!

When we move your site from ProStores to BigCommerce, we do all the heavy lifting. Your site will retain all of the product, category and customer data from your existing Prostores store. Enjoy all the benefits of BigCommerce’s innovative and ever-expanding technologies.

We will migrate your entire store!

We will move your existing site from ProStores to the BigCommerce platform professionally, correctly and quickly – Begin the transfer today.

ProStores is officially closing their doors Jan 31st 2015. ProStores has offered a really great deal to current ProStores.com merchants (not valid if you are hosted somewhere else, please see the package below). Please see the new migration center in your ProStores Admin confirm your details. They are offering free product, customer, category migration, free 301 redirects for all your store’s pages so that you lose very little of the carefully developed rankings you’ve cultured over the years of being open.

ProStores and Bigcommerce are offering free product, customer, and category migration, free 301 redirects for all your store’s pages so that you lose very little of the carefully developed rankings you’ve cultured over the years of being open, as well as reduced monthly fee. Please see your admin for full details.

We know that its a tough situation and we have the experience in ProStores and BigCommerce to help you move smoothly. Since ProStores and BigCommerce are not able to help you move your design we are offering a design integration and store configuration special. If you are currently hosted with prostores.com we will discount our package below by $600 (making it $1395.00). You will need to email [email protected] to get a special link for that price. While BigCommerce does its work we will duplicate your store design in BigCommerce and set up all your store settings for you. We will help you go down the Migration checklist that ProStores has provided for you and get you moved into your new home with ease. If you use related products we will need to review how many you have as Bigcommerce will not migrate those and we have to charge for that work because its use among merchants is so varied. Also if you use Google Shopping we will need to set up your store categories and edit your products in bulk to make sure that works. Again the use and complexity of each merchants Google Shopping set up varies too widely to include in our migration package and would require an additional fee, thankfully most of that particular process isn’t too difficult and won’t be too expensive. But we will need to review your products and export files to give an accurate quote.

What we and Bigcommerce will do for your store as a part of their migration and our migration offerings.

  • Product database *
  • Product images
  • Including multiple product images
  • Product attributes
  • Including price changing product attributes
  • Related products
  • Customer database
  • 301 Redirects for all pages
  • Categories and subcategories *
  • Logo, design template and color scheme port (example #1, example #2, example #3)
  • DNS support and consulting
Not a ProStores.com merchant? Ask us how to save yourself $600 off our regular price! If you are hosted on ProStores we will discount our package automatically by $600 (making it $1395.00). You will need to email [email protected] to get a special link for that price.
If you use related products we will need to review how many you have as Bigcommerce will not migrate those and we have to charge for that work because its use among merchants is so varied. Also if you use Google Shopping we will need to set up your store categories and edit your products in bulk to make sure that works. Again the use and complexity of each merchants Google Shopping set up varies too widely to include in our migration package and would require an additional fee, thankfully most of that particular process isn’t too difficult and won’t be too expensive. But we will need to review your products and export files to give an accurate quote

Moving your website will never be easier! Offering power and flexibility as well as enterprise-level tools at a price that every business can afford. BigCommerce is a world class, fully functional eCommerce platform for small-medium-large businesses. Move your store from ProStores to BigCommerce now with help from One Take Media’s Ecommerce Experts!

Total: $1,995.00

  • Deposit: $895.00

Remainder to be paid after completion of design transfer and store settings migration.

You can also pay in full at start to save $200!


Payment Options



*please contact us first about product catalogs over 300,000 unique items, or 5,000 categories. Special setup and pricing may be required depending on your situation.

ProStores to BigCommerce Store Transfer / Migration

Store Transfer and Migration from ProStores to BigCommerce, made easier!

When we move your site from ProStores to BigCommerce, we do all the heavy lifting. Your site will retain all of the product, category and customer data from your existing Prostores store. Enjoy all the benefits of BigCommerce’s innovative and ever-expanding technologies.

We will migrate your entire store!

We will move your existing site from ProStores to the BigCommerce platform professionally, correctly and quickly – Begin the transfer today.

ProStores is officially closing their doors Jan 31st 2015. ProStores has offered a really great deal to current ProStores.com merchants (not valid if you are hosted somewhere else, please see the package below). Please see the new migration center in your ProStores Admin confirm your details. They are offering free product, customer, category migration, free 301 redirects for all your store’s pages so that you lose very little of the carefully developed rankings you’ve cultured over the years of being open.

ProStores and Bigcommerce are offering free product, customer, and category migration, free 301 redirects for all your store’s pages so that you lose very little of the carefully developed rankings you’ve cultured over the years of being open, as well as reduced monthly fee. Please see your admin for full details.

We know that its a tough situation and we have the experience in ProStores and BigCommerce to help you move smoothly. Since ProStores and BigCommerce are not able to help you move your design we are offering a design integration and store configuration special. If you are currently hosted with prostores.com we will discount our package below by $600 (making it $1395.00). You will need to email [email protected] to get a special link for that price. While BigCommerce does its work we will duplicate your store design in BigCommerce and set up all your store settings for you. We will help you go down the Migration checklist that ProStores has provided for you and get you moved into your new home with ease. If you use related products we will need to review how many you have as Bigcommerce will not migrate those and we have to charge for that work because its use among merchants is so varied. Also if you use Google Shopping we will need to set up your store categories and edit your products in bulk to make sure that works. Again the use and complexity of each merchants Google Shopping set up varies too widely to include in our migration package and would require an additional fee, thankfully most of that particular process isn’t too difficult and won’t be too expensive. But we will need to review your products and export files to give an accurate quote.

What we and Bigcommerce will do for your store as a part of their migration and our migration offerings.

  • Product database *
  • Product images
  • Including multiple product images
  • Product attributes
  • Including price changing product attributes
  • Related products
  • Customer database
  • 301 Redirects for all pages
  • Categories and subcategories *
  • Logo, design template and color scheme port (example #1, example #2, example #3)
  • DNS support and consulting
Not a ProStores.com merchant? Ask us how to save yourself $600 off our regular price! If you are hosted on ProStores we will discount our package automatically by $600 (making it $1395.00). You will need to email [email protected] to get a special link for that price.
If you use related products we will need to review how many you have as Bigcommerce will not migrate those and we have to charge for that work because its use among merchants is so varied. Also if you use Google Shopping we will need to set up your store categories and edit your products in bulk to make sure that works. Again the use and complexity of each merchants Google Shopping set up varies too widely to include in our migration package and would require an additional fee, thankfully most of that particular process isn’t too difficult and won’t be too expensive. But we will need to review your products and export files to give an accurate quote

Moving your website will never be easier! Offering power and flexibility as well as enterprise-level tools at a price that every business can afford. BigCommerce is a world class, fully functional eCommerce platform for small-medium-large businesses. Move your store from ProStores to BigCommerce now with help from One Take Media’s Ecommerce Experts!

Total: $1,995.00

  • Deposit: $895.00

Remainder to be paid after completion of design transfer and store settings migration.

You can also pay in full at start to save $200!


Payment Options



*please contact us first about product catalogs over 300,000 unique items, or 5,000 categories. Special setup and pricing may be required depending on your situation.