Integrating NetSuite and Magento: Questions for a successful integration

A few questions to ask your System Integrator when integrating an ecommerce platform(Magento) with NetSuite or any other ERP 1.    Slow Magento API(SOAP calls) How do we work/scale around this with so many calls to be made for order sync, shipping sync, stock sync, pricing sync,  etc ? What is the choreography? 2.    Shipping Rules
Continue reading Integrating NetSuite and Magento: Questions for a successful integration

Magento: How to build reporting datawarehouse for Magento?

Disclaimer : Below information is from my experience with Magento platform. Right! so you have experienced the kiss of death by your awesome report or a feed generation in the dead of night ? Why ? Data intensive jobs especially mundane tasks like sitemap/google feeds generation take up lot of your DB power and results
Continue reading Magento: How to build reporting datawarehouse for Magento?

Magento: Sales Order Line Item Schema

@Version 1.0      Table Name: reporting_sales_flat_order_item This table contains information about each line items as described below. If something does not fit into your ecommerce configuration, do give us a shout at info@suiteweekly.com Column title e.g value Description Notes item_id 1280555 Line Item ID This is the ID of the line item and can
Continue reading Magento: Sales Order Line Item Schema

Magento: Product Information Schema

@Version 1.0      Table Name: reporting_product_flat This table contains information about each product with all their attributes as described below. If some thing does not fit into your ecommerce configuration, do give us a shout at hello@reckless.io. We do understand many of these attributes do not make sense to your business. This is complete customisable using
Continue reading Magento: Product Information Schema