Magento :: NetSuite :: Warehouse (WMS) Integration Discovery Questions

If you want to run a few discovery sessions for a client who wants to deploy NetSuite in the ecommerce ecosystem, then here are a few questions to help you kick off. I have come up with these from my experiences deploying NetSuite in ECOMMERCE businesses. Below are targeted to Magento/NetSuite and a Warehouse Management
Continue reading Magento :: NetSuite :: Warehouse (WMS) Integration Discovery Questions

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: Sales Order Schema

@Version 1.0      Table Name: reporting_sales_flat_order This table contains information about orders as described below. If some thing does not fit into your ecommerce configuration, do give us a shout at info@suiteweekly.com . sales_flat_order Description entity_id Order ID in Magento state The order state describes the position of an order in the workflow. Can be
Continue reading Magento: Sales Order 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