MAGMI CLIENT WITH GOOGLE SHEET INTEGRATION DOCUMENTATION

Installation

Step 1:
Download the latest version of Magmi and upload to your existing Magento 1 root directory.

Tip: Don’t call the folder ‘Magmi’ (security through obscurity). Although Magmi is protected by a .htpassword it is still worth calling it something different like: ‘operations’, ‘product_manager’

Step 2:
Upload the ‘MGS’ package to the Magmi root folder.

Configuration

Step 1: Configure Magmi

Before we can import, we need to configure Magmi a little. There are many plugins available and all of the ones that we will use come bundled with Magmi already. Open the Magmi web interface by going to http://yoursite.com/yourfolder/web/magmi.php.

The main requirement is to setup the database connection with your details; here’s a link to the Magmi setup guide:
http://wiki.magmi.org/index.php?title=UI_Main_page_organization

Step 2: Setup your Google Sheet

For those of you with Magmi Spreadsheet experience build your spreadsheet in Google Sheets as you normally would. For more information go to:
http://wiki.magmi.org/index.php?title=Import_new_products

Finally, for MGS to run correctly, and to be able to make use of all of its features, you MUST add 2 other columns to your sheet. These columns help you control what product lines to import.

Has Changed –

This enables MGS to only import/update products in your Magento that you have edited and want to be uploaded. This means you don’t have to import the full sheet, if you only change a few records. Simply add a number ‘1’ in this column to signify a changed record.

Screen Shot 2017-01-25 at 13.26.14

Is New –

This enables MGS to only import/create products that you have marked as ‘new’. This means you don’t have to import the full sheet if you only change a few records. Simply add a number ‘1’ in this column to signify a new record.

Step 3: Configure MGS

In terms of initial configuration for the MGS client, all that is required is a Google Sheets publish link.

See this guide to publish a spreadsheet.

It’s pretty simple all you really need to remember is to publish the sheet you want to use as a .csv Then paste the link that Google gives you in the box detailed below. Check out a few other things you will need to know about the MGS Client interface.

Quick Setup Guide

Google Sheet Link goes in (A). This is the key that unlocks all the rest of the functionality so once you have pasted it in, ‘click save’ (E).
The page will refresh and all your column headings will appear in the ‘blue box section’ (F & G)

MGS

A) Google Sheets link

B) Override / enter a specific Store for for all products

C) Override / enter a specific Attribute Set for you next import

D) Set MGS to ‘Test Mode’ this means that the script you choose will run. However, no data will be imported into Magento. This is a useful functions as MGS gives you an output for debugging every import you do.

TIP: It’s worthwhile to always do a quick ‘dry run’ of any import into Magento. Scan over the out that MGS gives you and make sure you are confident everything is OK before doing it for real!

E) Save Button. Saves all settings you have entered.

F) Attributes that cannot be removed from an import.

G) Attributes you can remove from an import are in bold.

Running an Import

MGS2

H) Run a full spreadsheet import (should be rarely used, approach this with extreme caution)

I) Import New Products only. Products marked as ‘Is New’ = 1 will be imported.

J) Import Changed Products only. Products marked as ‘Has Changed’ = 1 will be imported.

K) Check if MGS has detected your Google Sheets changes.

TIP: Because changes made in Google Sheets don’t always update immediately, It doesn’t hurt to refresh your page a few times or wait a little while between imports. Once you see a list of SKU’s in this box go ahead and run the import.

L) Example of SKU’s ready for import

Running an Export

MGS3

MGS enables you to quickly and easily download a CSV of your products. It also lets you specify the attributes you want to export. The only requirement is that you split the attributes you would like to extract into 2 sections: Default and Custom Attributes.

M) Export Product Data into a CSV that’s downloadable to the browser.

N) A list of Magento ‘default’ attributes for your information.

O) Enter 2 comma separated lists, one for ‘Default Attributes’ and one for ‘Custom Attributes’

P) Save entry

Q) Run Export

Support, Licence & Disclaimer

This Module is free and open source which means anyone can use it, however The Northern Foundry accepts no responsibility for losses or damages to you website that may occur when using this module.

If you require support on this Module please contact workshop@thenortherfoundry.com for more information on the tariffs available.

Our Support

*all prices are ex VAT

[table “” not found /]