Megaventory API v2017a

<back to all web services

ProductUpdate

The following routes are available for this service:
POST/Product/ProductUpdateInserts a product or updates an existing one.Uses your API Key and applies a mvRecordAction value on an mvProduct object. We can insert the mvProduct object we specified using "Insert" as our mvRecordAction. We can update a current one using "Update", we can insert it if it doesn't already exist, update it if it does using "InsertOrUpdate" and we can insert new fields or update non-empty fields of the object using "InsertOrUpdateNonEmptyFields". Optionally, you can use mvInsertUpdateDeleteSourceApplication when an external application ( eg WooCommerce ) is the one that triggers the ProductUpdate call. ProductId cannot be updated.

Examples:



A.

Insert a new product. The ProductUpdate call was triggered by WooCommerce.

Value:

 {
   "mvProduct": {
      "ProductType": "TimeRestrictedService",
      "ProductSKU": "newproductsku",
      "ProductDescription": "newproductdescription"
   },
   "mvRecordAction": "Insert",
   "mvInsertUpdateDeleteSourceApplication": "WooCommerce"
}


Response: 

 {
   "mvProduct": {
      "ProductID": 55,
      "ProductType": "TimeRestrictedService",
      "ProductSKU": "newproductsku",
      "ProductEAN": "",
      "ProductDescription": "newproductdescription",
      "ProductVersion": "",
      "ProductLongDescription": "",
      "ProductCategoryID": 0,
      "ProductUnitOfMeasurement": "",
      "ProductSellingPrice": 0,
      "ProductPurchasePrice": 0,
      "ProductWeight": 0,
      "ProductLength": 0,
      "ProductBreadth": 0,
      "ProductHeight": 0,
      "ProductImageURL": "",
      "ProductComments": "",
      "ProductCustomField1": "",
      "ProductCustomField2": "",
      "ProductCustomField3": "",
      "ProductCustomField4": "",
      "ProductCustomField5": "",
      "ProductCustomField6": "",
      "ProductCustomField7": "",
      "ProductCustomField8": "",
      "ProductCustomField9": "",
      "ProductCustomField10": "",
      "ProductCustomField11": "",
      "ProductCustomField12": "",
      "ProductCustomField13": "",
      "ProductCustomField14": "",
      "ProductCustomField15": "",
      "ProductCustomField16": "",
      "ProductCustomField17": "",
      "ProductCustomField18": "",
      "ProductCustomField19": "",
      "ProductCustomField20": "",
      "ProductOption1": "",
      "ProductOption2": "",
      "ProductOption3": "",
      "ProductOption4": "",
      "ProductOption5": "",
      "ProductOption6": "",
      "ProductOption7": "",
      "ProductOption8": "",
      "ProductOption9": "",
      "ProductOption10": "",
      "ProductMainSupplierID": 0,
      "ProductMainSupplierPrice": 0,
      "ProductMainSupplierSKU": "",
      "ProductMainSupplierDescription": "",
      "ProductCreationDate": "/Date(1507650714280+0300)/"
   },
   "ResponseStatus": {
      "ErrorCode": "0"
   },
   "entityID": 55
}

B.

Update information on the product above. ProductID is mandatory and cannot be updated.

Value:

 {
   "mvProduct": {
      "ProductID": "55",
      "ProductSKU": "newproductsku",
      "ProductDescription": "newproductdescription -Updated!",
      "ProductSellingPrice": "1.16",
      "ProductPurchasePrice": "0.98",
      "mvProductMainSupplier": {
         "SupplierClientName": "A4 Paper Supplier"
      }
   },
   "mvRecordAction": "Update"
}


Response: 

 {
   "mvProduct": {
      "ProductID": 55,
      "ProductType": "BuyFromSupplier",
      "ProductSKU": "newproductsku",
      "ProductEAN": "",
      "ProductDescription": "newproductdescription -Updated!",
      "ProductVersion": "",
      "ProductLongDescription": "",
      "ProductCategoryID": 0,
      "ProductUnitOfMeasurement": "",
      "ProductSellingPrice": 1.16,
      "ProductPurchasePrice": 0.98,
      "ProductUnitCost": 0,
      "ProductWeight": 0,
      "ProductLength": 0,
      "ProductBreadth": 0,
      "ProductHeight": 0,
      "ProductImageURL": "",
      "ProductComments": "",
      "ProductCustomField1": "",
      "ProductCustomField2": "",
      "ProductCustomField3": "",
      "ProductCustomField4": "",
      "ProductCustomField5": "",
      "ProductCustomField6": "",
      "ProductCustomField7": "",
      "ProductCustomField8": "",
      "ProductCustomField9": "",
      "ProductCustomField10": "",
      "ProductCustomField11": "",
      "ProductCustomField12": "",
      "ProductCustomField13": "",
      "ProductCustomField14": "",
      "ProductCustomField15": "",
      "ProductCustomField16": "",
      "ProductCustomField17": "",
      "ProductCustomField18": "",
      "ProductCustomField19": "",
      "ProductCustomField20": "",
      "ProductOption1": "",
      "ProductOption2": "",
      "ProductOption3": "",
      "ProductOption4": "",
      "ProductOption5": "",
      "ProductOption6": "",
      "ProductOption7": "",
      "ProductOption8": "",
      "ProductOption9": "",
      "ProductOption10": "",
      "ProductMainSupplierID": 0,
      "ProductMainSupplierPrice": 0,
      "ProductMainSupplierSKU": "",
      "ProductMainSupplierDescription": "",
      "ProductCreationDate": "/Date(1507650714280-0000)/"
   },
   "ResponseStatus": {
      "ErrorCode": "0"
   },
   "entityID": 55
}

To override the Content-type in your clients HTTP Accept Header, append the .csv suffix or ?format=csv

HTTP + CSV

The following are sample HTTP requests and responses. The placeholders shown need to be replaced with actual values.

POST /csv/reply/ProductUpdate HTTP/1.1 
Host: api.megaventory.com 
Content-Type: text/csv
Content-Length: length

ProductID,ProductType,ProductSKU,ProductEAN,ProductDescription,ProductVersion,ProductLongDescription,ProductCategoryID,mvProductCategory,ProductUnitOfMeasurement,ProductSellingPrice,ProductPurchasePrice,ProductUnitCost,ProductWeight,ProductWeightUnitID,mvProductWeightUnit,ProductLength,ProductBreadth,ProductHeight,ProductImageURL,ProductComments,ProductCustomField1,ProductCustomField2,ProductCustomField3,ProductCustomField4,ProductCustomField5,ProductCustomField6,ProductCustomField7,ProductCustomField8,ProductCustomField9,ProductCustomField10,ProductCustomField11,ProductCustomField12,ProductCustomField13,ProductCustomField14,ProductCustomField15,ProductCustomField16,ProductCustomField17,ProductCustomField18,ProductCustomField19,ProductCustomField20,ProductMainSupplierID,mvProductMainSupplier,ProductMainSupplierPrice,ProductMainSupplierSKU,ProductMainSupplierDescription,ProductCreationDate,ProductOption1,ProductOption2,ProductOption3,ProductOption4,ProductOption5,ProductOption6,ProductOption7,ProductOption8,ProductOption9,ProductOption10,IsInventorySerialised,IsBatchNumbersEnabled,SerialNumberPrefix,SerialNumberLength,IsPurchasable,PurchasableStartDate,PurchasableEndDate,IsSellable,SellableStartDate,SellableEndDate
0,BuyFromSupplier,String,String,String,String,String,0,"{ProductCategoryID:0,ProductCategoryName:String,ProductCategoryDescription:String}",String,0,0,[{}],0,0,"{WeightUnitID:0,WeightUnitAbbrev:String,WeightUnitName:String,WeightUnitConversionToGrams:0}",0,0,0,String,String,String,String,String,String,String,String,String,String,String,String,String,String,String,String,String,String,String,String,String,String,0,"{SupplierClientID:0,SupplierClientType:Both,SupplierClientName:String,SupplierClientBillingAddress:String,SupplierClientShippingAddress1:String,SupplierClientShippingAddress2:String,SupplierClientAddresses:[{AddressType:General,AddressLine1:String,AddressLine2:String,AddressLine3:String,Name:String,Phone:String,Email:String,TaxIdNumber:String,Organization:String,City:String,State:String,Country:NONE,CountryName:String,Longitude:String,Latitude:String,ZipCode:String}],SupplierClientPhone1:String,SupplierClientPhone2:String,SupplierClientFax:String,SupplierClientIM:String,SupplierClientEmail:String,SupplierClientCurrency:String,SupplierClientPaymentTermsEnum:None,SupplierClientPaymentMethodEnum:None,SupplierClientComments:String,SupplierClientCustomField1:String,SupplierClientCustomField2:String,SupplierClientCustomField3:String,SupplierClientCustomField4:String,SupplierClientCustomField5:String,SupplierClientCustomField6:String,SupplierClientCustomField7:String,SupplierClientCustomField8:String,SupplierClientCustomField9:String,SupplierClientCustomField10:String,SupplierClientOption1:False,SupplierClientOption2:False,SupplierClientOption3:False,SupplierClientOption4:False,SupplierClientOption5:False,SupplierClientOption6:False,SupplierClientOption7:False,SupplierClientOption8:False,SupplierClientOption9:False,SupplierClientOption10:False,SupplierClientCreationDate:0001-01-01,mvContacts:[{ContactId:0,ContactName:String,ContactDepartment:String,ContactAddress:String,ContactFullAddress:{AddressType:General,AddressLine1:String,AddressLine2:String,AddressLine3:String,Name:String,Phone:String,Email:String,TaxIdNumber:String,Organization:String,City:String,State:String,Country:NONE,CountryName:String,Longitude:String,Latitude:String,ZipCode:String},ContactEmail:String,ContactPhone1:String,ContactPhone2:String,ContactFax:String,ContactIM:String,ContactCustomField1:String,ContactCustomField2:String,ContactIsPrimary:False,mvSuppliersClients:[{SupplierClientID:0,SupplierClientType:Both,SupplierClientName:String,SupplierClientBillingAddress:String,SupplierClientShippingAddress1:String,SupplierClientShippingAddress2:String,SupplierClientAddresses:[{AddressType:General,AddressLine1:String,AddressLine2:String,AddressLine3:String,Name:String,Phone:String,Email:String,TaxIdNumber:String,Organization:String,City:String,State:String,Country:NONE,CountryName:String,Longitude:String,Latitude:String,ZipCode:String}],SupplierClientPhone1:String,SupplierClientPhone2:String,SupplierClientFax:String,SupplierClientIM:String,SupplierClientEmail:String,SupplierClientCurrency:String,SupplierClientPaymentTermsEnum:None,SupplierClientPaymentMethodEnum:None,SupplierClientComments:String,SupplierClientCustomField1:String,SupplierClientCustomField2:String,SupplierClientCustomField3:String,SupplierClientCustomField4:String,SupplierClientCustomField5:String,SupplierClientCustomField6:String,SupplierClientCustomField7:String,SupplierClientCustomField8:String,SupplierClientCustomField9:String,SupplierClientCustomField10:String,SupplierClientOption1:False,SupplierClientOption2:False,SupplierClientOption3:False,SupplierClientOption4:False,SupplierClientOption5:False,SupplierClientOption6:False,SupplierClientOption7:False,SupplierClientOption8:False,SupplierClientOption9:False,SupplierClientOption10:False,SupplierClientCreationDate:0001-01-01,mvContacts:[{ContactId:0,ContactName:String,ContactDepartment:String,ContactAddress:String,ContactFullAddress:{AddressType:General,AddressLine1:String,AddressLine2:String,AddressLine3:String,Name:String,Phone:String,Email:String,TaxIdNumber:String,Organization:String,City:String,State:String,Country:NONE,CountryName:String,Longitude:String,Latitude:String,ZipCode:String},ContactEmail:String,ContactPhone1:String,ContactPhone2:String,ContactFax:String,ContactIM:String,ContactCustomField1:String,ContactCustomField2:String,ContactIsPrimary:False,mvSuppliersClients:[{SupplierClientID:0,SupplierClientType:Both,SupplierClientName:String,SupplierClientBillingAddress:String,SupplierClientShippingAddress1:String,SupplierClientShippingAddress2:String,SupplierClientAddresses:[{AddressType:General,AddressLine1:String,AddressLine2:String,AddressLine3:String,Name:String,Phone:String,Email:String,TaxIdNumber:String,Organization:String,City:String,State:String,Country:NONE,CountryName:String,Longitude:String,Latitude:String,ZipCode:String}],SupplierClientPhone1:String,SupplierClientPhone2:String,SupplierClientFax:String,SupplierClientIM:String,SupplierClientEmail:String,SupplierClientCurrency:String,SupplierClientPaymentTermsEnum:None,SupplierClientPaymentMethodEnum:None,SupplierClientComments:String,SupplierClientCustomField1:String,SupplierClientCustomField2:String,SupplierClientCustomField3:String,SupplierClientCustomField4:String,SupplierClientCustomField5:String,SupplierClientCustomField6:String,SupplierClientCustomField7:String,SupplierClientCustomField8:String,SupplierClientCustomField9:String,SupplierClientCustomField10:String,SupplierClientOption1:False,SupplierClientOption2:False,SupplierClientOption3:False,SupplierClientOption4:False,SupplierClientOption5:False,SupplierClientOption6:False,SupplierClientOption7:False,SupplierClientOption8:False,SupplierClientOption9:False,SupplierClientOption10:False,SupplierClientCreationDate:0001-01-01,mvContacts:[{ContactId:0,ContactName:String,ContactDepartment:String,ContactAddress:String,ContactFullAddress:{AddressType:General,AddressLine1:String,AddressLine2:String,AddressLine3:String,Name:String,Phone:String,Email:String,TaxIdNumber:String,Organization:String,City:String,State:String,Country:NONE,CountryName:String,Longitude:String,Latitude:String,ZipCode:String},ContactEmail:String,ContactPhone1:String,ContactPhone2:String,ContactFax:String,ContactIM:String,ContactCustomField1:String,ContactCustomField2:String,ContactIsPrimary:False,mvSuppliersClients:[{}]}],SupplierClientTaxID:String}]}],SupplierClientTaxID:String}]}],SupplierClientTaxID:String}",0.00,String,String,0001-01-01,False,False,False,False,False,False,False,False,False,False,False,False,String,,False,0001-01-01,0001-01-01,False,0001-01-01,0001-01-01


HTTP/1.1 200 OK
Content-Type: text/csv
Content-Length: length

ProductID,ProductType,ProductSKU,ProductEAN,ProductDescription,ProductVersion,ProductLongDescription,ProductCategoryID,mvProductCategory,ProductUnitOfMeasurement,ProductSellingPrice,ProductPurchasePrice,ProductUnitCost,ProductWeight,ProductWeightUnitID,mvProductWeightUnit,ProductLength,ProductBreadth,ProductHeight,ProductImageURL,ProductComments,ProductCustomField1,ProductCustomField2,ProductCustomField3,ProductCustomField4,ProductCustomField5,ProductCustomField6,ProductCustomField7,ProductCustomField8,ProductCustomField9,ProductCustomField10,ProductCustomField11,ProductCustomField12,ProductCustomField13,ProductCustomField14,ProductCustomField15,ProductCustomField16,ProductCustomField17,ProductCustomField18,ProductCustomField19,ProductCustomField20,ProductMainSupplierID,mvProductMainSupplier,ProductMainSupplierPrice,ProductMainSupplierSKU,ProductMainSupplierDescription,ProductCreationDate,ProductOption1,ProductOption2,ProductOption3,ProductOption4,ProductOption5,ProductOption6,ProductOption7,ProductOption8,ProductOption9,ProductOption10,IsInventorySerialised,IsBatchNumbersEnabled,SerialNumberPrefix,SerialNumberLength,IsPurchasable,PurchasableStartDate,PurchasableEndDate,IsSellable,SellableStartDate,SellableEndDate
0,BuyFromSupplier,String,String,String,String,String,0,"{ProductCategoryID:0,ProductCategoryName:String,ProductCategoryDescription:String}",String,0,0,[{}],0,0,"{WeightUnitID:0,WeightUnitAbbrev:String,WeightUnitName:String,WeightUnitConversionToGrams:0}",0,0,0,String,String,String,String,String,String,String,String,String,String,String,String,String,String,String,String,String,String,String,String,String,String,0,"{SupplierClientID:0,SupplierClientType:Both,SupplierClientName:String,SupplierClientBillingAddress:String,SupplierClientShippingAddress1:String,SupplierClientShippingAddress2:String,SupplierClientAddresses:[{AddressType:General,AddressLine1:String,AddressLine2:String,AddressLine3:String,Name:String,Phone:String,Email:String,TaxIdNumber:String,Organization:String,City:String,State:String,Country:NONE,CountryName:String,Longitude:String,Latitude:String,ZipCode:String}],SupplierClientPhone1:String,SupplierClientPhone2:String,SupplierClientFax:String,SupplierClientIM:String,SupplierClientEmail:String,SupplierClientCurrency:String,SupplierClientPaymentTermsEnum:None,SupplierClientPaymentMethodEnum:None,SupplierClientComments:String,SupplierClientCustomField1:String,SupplierClientCustomField2:String,SupplierClientCustomField3:String,SupplierClientCustomField4:String,SupplierClientCustomField5:String,SupplierClientCustomField6:String,SupplierClientCustomField7:String,SupplierClientCustomField8:String,SupplierClientCustomField9:String,SupplierClientCustomField10:String,SupplierClientOption1:False,SupplierClientOption2:False,SupplierClientOption3:False,SupplierClientOption4:False,SupplierClientOption5:False,SupplierClientOption6:False,SupplierClientOption7:False,SupplierClientOption8:False,SupplierClientOption9:False,SupplierClientOption10:False,SupplierClientCreationDate:0001-01-01,mvContacts:[{ContactId:0,ContactName:String,ContactDepartment:String,ContactAddress:String,ContactFullAddress:{AddressType:General,AddressLine1:String,AddressLine2:String,AddressLine3:String,Name:String,Phone:String,Email:String,TaxIdNumber:String,Organization:String,City:String,State:String,Country:NONE,CountryName:String,Longitude:String,Latitude:String,ZipCode:String},ContactEmail:String,ContactPhone1:String,ContactPhone2:String,ContactFax:String,ContactIM:String,ContactCustomField1:String,ContactCustomField2:String,ContactIsPrimary:False,mvSuppliersClients:[{SupplierClientID:0,SupplierClientType:Both,SupplierClientName:String,SupplierClientBillingAddress:String,SupplierClientShippingAddress1:String,SupplierClientShippingAddress2:String,SupplierClientAddresses:[{AddressType:General,AddressLine1:String,AddressLine2:String,AddressLine3:String,Name:String,Phone:String,Email:String,TaxIdNumber:String,Organization:String,City:String,State:String,Country:NONE,CountryName:String,Longitude:String,Latitude:String,ZipCode:String}],SupplierClientPhone1:String,SupplierClientPhone2:String,SupplierClientFax:String,SupplierClientIM:String,SupplierClientEmail:String,SupplierClientCurrency:String,SupplierClientPaymentTermsEnum:None,SupplierClientPaymentMethodEnum:None,SupplierClientComments:String,SupplierClientCustomField1:String,SupplierClientCustomField2:String,SupplierClientCustomField3:String,SupplierClientCustomField4:String,SupplierClientCustomField5:String,SupplierClientCustomField6:String,SupplierClientCustomField7:String,SupplierClientCustomField8:String,SupplierClientCustomField9:String,SupplierClientCustomField10:String,SupplierClientOption1:False,SupplierClientOption2:False,SupplierClientOption3:False,SupplierClientOption4:False,SupplierClientOption5:False,SupplierClientOption6:False,SupplierClientOption7:False,SupplierClientOption8:False,SupplierClientOption9:False,SupplierClientOption10:False,SupplierClientCreationDate:0001-01-01,mvContacts:[{ContactId:0,ContactName:String,ContactDepartment:String,ContactAddress:String,ContactFullAddress:{AddressType:General,AddressLine1:String,AddressLine2:String,AddressLine3:String,Name:String,Phone:String,Email:String,TaxIdNumber:String,Organization:String,City:String,State:String,Country:NONE,CountryName:String,Longitude:String,Latitude:String,ZipCode:String},ContactEmail:String,ContactPhone1:String,ContactPhone2:String,ContactFax:String,ContactIM:String,ContactCustomField1:String,ContactCustomField2:String,ContactIsPrimary:False,mvSuppliersClients:[{SupplierClientID:0,SupplierClientType:Both,SupplierClientName:String,SupplierClientBillingAddress:String,SupplierClientShippingAddress1:String,SupplierClientShippingAddress2:String,SupplierClientAddresses:[{AddressType:General,AddressLine1:String,AddressLine2:String,AddressLine3:String,Name:String,Phone:String,Email:String,TaxIdNumber:String,Organization:String,City:String,State:String,Country:NONE,CountryName:String,Longitude:String,Latitude:String,ZipCode:String}],SupplierClientPhone1:String,SupplierClientPhone2:String,SupplierClientFax:String,SupplierClientIM:String,SupplierClientEmail:String,SupplierClientCurrency:String,SupplierClientPaymentTermsEnum:None,SupplierClientPaymentMethodEnum:None,SupplierClientComments:String,SupplierClientCustomField1:String,SupplierClientCustomField2:String,SupplierClientCustomField3:String,SupplierClientCustomField4:String,SupplierClientCustomField5:String,SupplierClientCustomField6:String,SupplierClientCustomField7:String,SupplierClientCustomField8:String,SupplierClientCustomField9:String,SupplierClientCustomField10:String,SupplierClientOption1:False,SupplierClientOption2:False,SupplierClientOption3:False,SupplierClientOption4:False,SupplierClientOption5:False,SupplierClientOption6:False,SupplierClientOption7:False,SupplierClientOption8:False,SupplierClientOption9:False,SupplierClientOption10:False,SupplierClientCreationDate:0001-01-01,mvContacts:[{ContactId:0,ContactName:String,ContactDepartment:String,ContactAddress:String,ContactFullAddress:{AddressType:General,AddressLine1:String,AddressLine2:String,AddressLine3:String,Name:String,Phone:String,Email:String,TaxIdNumber:String,Organization:String,City:String,State:String,Country:NONE,CountryName:String,Longitude:String,Latitude:String,ZipCode:String},ContactEmail:String,ContactPhone1:String,ContactPhone2:String,ContactFax:String,ContactIM:String,ContactCustomField1:String,ContactCustomField2:String,ContactIsPrimary:False,mvSuppliersClients:[{}]}],SupplierClientTaxID:String}]}],SupplierClientTaxID:String}]}],SupplierClientTaxID:String}",0.00,String,String,0001-01-01,False,False,False,False,False,False,False,False,False,False,False,False,String,,False,0001-01-01,0001-01-01,False,0001-01-01,0001-01-01