metafields.py

import csv
import time
import shopify

import optparse


parser = optparse.OptionParser()
parser.add_option('--api_key', action="store" )
parser.add_option('--password', action="store" )
parser.add_option('--store_name', action="store" )
parser.add_option('--csv_file', action="store" )
parser.add_option('--variant_id', action="store" )

options, args = parser.parse_args()

if not options.api_key:   
    parser.error('--api-key not given not given')
if not options.password:   
    parser.error('--password not given not given')
if not options.store_name:   
    parser.error('--store_name not given not given')
if not options.csv_file:   
    parser.error('--csv_file not given not given')

shop_url = "https://%s:%s@%s/admin" % (options.api_key, options.password, options.store_name)
shopify.ShopifyResource.set_site(shop_url)

shop = shopify.Shop.current


with open(options.csv_file) as csvfile:
    readCSV = csv.reader(csvfile, delimiter=',')
    next(csvfile) # skip 2 lines
    next(csvfile)
    rowcount=0
    bad_results = []
    products = []
    for row in readCSV:

        product_name = row[0]
        variant_id = row[1]

        if(options.variant_id and options.variant_id != variant_id):
            continue

        time.sleep(2)
        v=shopify.Variant.find(variant_id)
        if(v.product_id in products):
            continue
        time.sleep(2)
        p=shopify.Product.find(v.product_id)
        print "Product: %s \n" % (p.title)
        
        metafield = shopify.Metafield({'value_type': 'integer', 'namespace': 'seo', 'value': 1, 'key': 'hidden'})
        time.sleep(2)
        p.add_metafield(metafield)
                    
        if(rowcount % 2 == 0):
            time.sleep(2)
        rowcount += 1
        products.append(v.product_id)

        
        
    
print ("Error results\n")
print "\n".join(bad_results)