# consumer_key=settings.WOO_CONSUMER_KEY,
# consumer_secret=settings.WOO_CONSUMER_SECRET,
# timeout=60
#)
#data = wcapi.get("products?filter[limit]=1000")
#f = open('woo_products.json', 'wt')
#f.write(data.text)
#sys.exit(0)
data = open('woo_products.json', 'rt').read()
data_json = json.loads(data)
items = data_json['products']
logger.info("Found %d items", len(items))
saved = 0
for i in items:
slug_title = snake_string(i['title'])
product, created = C2OProduct.objects.get_or_create(unique_id=slug_title)
if created:
product.sku_name = "Gildan Men's Ring Spun, SoftStyle T-Shirt"
product.woo_listing_id = i['sku']
product.title = i['title']
product.description = i['description']
product.save()
product.woo_variants.all().delete()
for var in i['variations']:
WooVariantSku.objects.create(product = product, sku = var['sku'])
saved += 1
logger.info("Saved %d products", saved)
except:
err = get_exception_trace()
logger.error(err)
django.setup()
logger = logging.getLogger("project")
# add your project directory to the sys.path
from lumacart_console.catalogue.models import C2OProduct
from lumacart_console.orders.etsy import EtsyAPI
from lumacart_console.utils import get_exception_trace, snake_string
from django.conf import settings
try:
logger.info("Syncing products from Etsy...")
etsy = EtsyAPI(settings.ETSY_SHOP_ID, settings.ETSY_CLIENT_KEY, settings.ETSY_CLIENT_SECRET, settings.ETSY_RESOURCE_OWNER_KEY, settings.ETSY_RESOURCE_OWNER_SECRET)
items = etsy.get_shop_active_items()
logger.info("Found %d items", len(items))
saved = 0
for i in items:
title = html.unescape(i['title'])
slug_title = snake_string(title)
product, created = C2OProduct.objects.get_or_create(unique_id=slug_title)
if created:
product.sku_name = "Gildan Men's Ring Spun, SoftStyle T-Shirt"
product.etsy_listing_id = i['listing_id']
product.title = title
product.description = i['description']
product.save()
saved += 1
logger.info("Saved %d products", saved)
except:
err = get_exception_trace()
logger.error(err)
