class getSales:
def __init__(self, db, credentials):
self.db = db
self.credentials = credentials
def fetch(self):
sales = Sales(self.credentials)
self.sales = sales.get()
return self
def syncNeeded(self):
date = self.sale.last_updated
last_updated = self.sale.getLastUpdated()
if last_updated != False:
last_updated = last_updated[0][0].strftime("%Y-%m-%d %H:%M:%S")
if date == last_updated:
return False
return True
def parse(self):
for sale in self.sales['orders']:
self.sale = Sale(self.db)
self.line = Line(self.db)
self.payment = Payment(self.db)
self.address = Address(self.db)
self.transaction = Transaction(self.db)
order_id = sale['orderId'].split('!')[0]
self.sale.setOrderId(order_id)
self.line.setOrderId(order_id)
self.address.setOrderId(order_id)
self.sale.setLastUpdated(sale['lastModifiedDate'])
if self.syncNeeded():
self.sale.setLegacyOrderId(sale['legacyOrderId'])
self.sale.setSaleDate(sale['creationDate'])
self.sale.setBuyerUsername(sale['buyer']['username'])
self.sale.setStatus(sale['orderAddressStatus'])
self.sale.add()
self.fee = Fee(self.db)
self.fee.setOrderId(order_id)
self.fee.setFinalValueFee(sale['totalMarketplaceFee']['value'])
self.fee.addEbayFee()
for line_items in sale['lineItems']:
self.line_item_id = line_items['lineItemId']
self.line.setItemId(line_items['legacyItemId'])
self.line.setLineItemId(self.line_item_id)
self.line.setTitle(line_items['title'])
self.line.setSaleFormat(line_items['soldFormat'])
self.line.setQuantity(line_items['quantity'])
self.line.setAddressStatus(
line_items['lineItemAddressStatus'])
self.line.add()
self.payment.setLineItemId(self.line_item_id)
self.payment.setCurrency(
line_items['lineItemCost']['convertedFromCurrency'])
self.payment.setItemCost(
line_items['lineItemCost']['convertedFromValue'])
self.payment.setPostageCost(
line_items['deliveryCost']['shippingCost']
['convertedFromValue'])
for payment in sale['paymentSummary']['payments']:
self.transaction.setProcessorName(payment['paymentMethod'])
self.transaction.setProcessorId(
sale['salesRecordReference'])
self.transaction.setTransactionDate(payment['paymentDate'])
self.transaction.setUpdateDate(payment['paymentDate'])
self.transaction.setTransactionAmount(
sale['pricingSummary']['total']['value'])
self.transaction.setTransactionCurrency(
sale['pricingSummary']['total']['currency'])
self.transaction.setFeeAmount(0)
self.transaction.setFeeCurrency(
sale['pricingSummary']['total']['currency'])
self.transaction.setTransactionStatus('S')
if not self.transaction.alreadyExists():
transaction_id = self.transaction.add()
self.payment.setPaymentDate(payment['paymentDate'])
self.payment.setPaymentStatus(payment['paymentStatus'])
self.payment.setTransactionId(transaction_id)
self.payment.add()
for shipping in sale['AddressStartInstructions']:
ship_to = shipping['shippingStep']['shipTo']
self.address.setBuyerName(ship_to['fullName'])
self.address.setAddressLine1(
ship_to['contactAddress']['addressLine1'])
self.address.setCity(ship_to['contactAddress']['city'])
try:
self.address.setCounty(
ship_to['contactAddress']['stateOrProvince'])
except KeyError:
self.address.setCounty("")
self.address.setPostCode(
ship_to['contactAddress']['postalCode'])
self.address.setCountryCode(
ship_to['contactAddress']['countryCode'])
self.address.add()
