Magento themes and extensions

Magento: How to use the Import/Export Tool

Posted on April 4th, 2013 | Posted by admin

The import/export tool is very useful within Magento. Being that there is limited documentation on the topic, I thought I would add my .02.

Basically you can use the import/export tool to do mass imports of products. It makes it much easier if you would like to add 50 products all at once, you would just create a csv or xml file with the matching fields for the database, add your information and then use the import tool to import the products. You can retrieve a sample csv or xml file, but doing an export.

Doing an export is very easy, and allows you to export all of your products out of your website. You might want to do this, if you are moving your website or need to reinstall or upgrade your website, and need to get the products out.

Import Configurable Products in Magento

Posted on February 23rd, 2013 | Posted by admin

Import Configurable Products in Magento
Importing Configurable Products is another great feature that comes with Magmi, but it can be a bit confusing for some, due to configurable and simple product having different columns and column count.

Start by creating a configurable product manually via the admin to assure that the super attribute and simple product relations are set-up correctly and working. After you successfully created a configurable product to go by, you can start with your configurable product spreadsheet, which requires less column headers due to most coming from the simple products. In a duplicated version of the simple products spreadsheet, cut down the values to the following (but do leave the columns you may require, such as page layout or custom designs if you intend to use them):

How to Import Products into Magento

Posted on November 2nd, 2012 | Posted by admin

There’s a little confusion among some on how to import products into a Magento ecommerce store. I spent some time today researching and trying to find the best method on doing this. The reason for my research is because there was no simple documentation anywhere that I could find on how to import products. Magento actually has built a pretty robust import/export mechanism into the ecommerce cms that has a ton of flexibility to do many things. I’m not going to cover all of those. This is just for those of you who simply just want to import products into their Magento cart.

Step 1 – Add a new product manually
add a new product manually to the catalog, assign it to a category, and fill out all fields that will be necessary to your store. The obvious ones are price, description, quantity etc. It’s important that you fill out all fields that you know you are going to need for all the products you import.

How do I import or export my MySQL database using SSH

Posted on September 22nd, 2012 | Posted by admin

Your MySQL databases can be administered through an SSH session via command line (especially if you have large sized data to import/export). To access your account using SSH you must subscribe to a hosting plan that supports this feature.

Enable SSH for your account:

  1. Login to your Netfirms Control Panel.
  2. Click Hosting.
  3. Click Settings.
  4. Select Enable in the SSH pull-down menu.

We suggest using Putty to connect to your account as it is a freely available SSH client for windows.

SSH connections can be established with the following login credentials:

Magento: Category Import Script?

Posted on June 2nd, 2011 | Posted by admin

Currently, there is no way to import categories unless you write your own script or sql. I may have a project coming up soon that will require importing a lot of categories, so I may have to build a better script (I’ve built a couple crappy ones already) for importing them. But, before I do that, I’d like to get some feedback.

First – CSV setup. What I’m assuming the best global way to import is from a CSV (correct me if I’m wrong). In that case, what do you think the best format of the CSV should be? My initial thoughts would be 2 columns. First one for the category name, second (if used) is for which category name the category is nested under. (I suppose there could be other columns as well for Enabled or Disabled, meta, image, etc.)

Second – Anything else that would be useful for a category import script?

I can’t guarentee that I’ll be able to have the time to do this – but we’ll see. The better and level of feedback I get, the more motivation I’ll probably have!

Page 1 of 212»