Magento E-Comm - Using the Bundle

Managing Items

Default Mapping of NetSuite fields to Magento attributes

These are the default fields that are available with the Cloud Coders Magento E-Commerce Integration fields mapping from Netsuite to Magento. 

NetSuite Name
Magento Name
Notes
WEB STORE DISPLAY NAMEName
DETAILED DESCRIPTIONDescription
WEB STORE DESCRIPTIONShort Description
ITEM NAME/NUMBERSKU
WEIGHTWeight
MI ENABLE PRODUCTStatus

URL KeyGenerated from the product SKU

VisibilityVisible in Catalog and Search by default
INTERNAL IDNetsuite item iDCannot be changed
PRICE LEVELPriceThe default price level map
PRICE LEVELGroup PriceBased on the mapped price level to Magento groups
MI SPECIAL PRICESpecial Price
MI SPECIAL PRICE FROM DATESpecial Price From Date
MI SPECIAL PRICE TO DATESpecial price to Date
PRICE LEVELTier PriceBased on the price level quantity pricing
MI MANUFACTURER SUGGESTED RETAIL PRICEManufacturer's Suggested Retail Price

Tax ClassBy default it is "Taxable Goods"
ITEM DISPLAY IMAGE, ITEM DISPLAY THUMBNAILImages
CUSTOM IMAGES _picture1 to _picture11Images

Inventory (Qty)Calculated from the item quantity. Only warehouses that has "Make available in store" are used

Inventory (Stock Availability)

This field is set in/out of stock the first time the product is created. Further update of this field can be

regulated by using the configuration "Set stock availability"

MI ITEM MAGENTO STORESWebsites
WEB SITE CATEGORIESCategories
RELATED ITEMSRelated Products
SEARCH KEYWORDSProduct Tags

Magento Tab Field Descriptions

The Magento tab in Netsuite provides options for managing items in Magento.

 Field
 Description
MI Display in MagentoEnables the product to be managed from Netsuite with updates sent to Magento. If unticked product will be disabled in Magento. Note: If disabling the item in Netsuite, first untick MI Display in Magento & Enable Product then save. This will ensure product is disabled in Magento as well.
MI Disable Magento UpdateThis is where the customer would like to update the Item in Netsuite but not send it to Magento.
Enable ProductEnable or disable the display of this product in Magento. This field is linked to the Status field in the Magento item.
MI Magento StoresThis may be left blank if only using one store. If multiple stores in use then select the stores this item may appear in.
MI Force Price UpdatePrices will be updated instantly without waiting for the scheduled job. Once you save this item this tick box will reset itself.
MI Manufacture retail PriceManufacture RRP that may be displayed on website.
MI Special Price from DateStart date of a special price.
MI Last Magento Price Updated StatusStatus of the last Force Price update.
MI Special Price to DateThis is the end date of the special price.
MI Special PriceSet the price in here for specials.

MI Last Magento Update time

Date and time of last update.
MI Due DateUsed to display the date item is due back in stock.
MI last Stock update date & timeDate and time of last stock level update.
MI Height, Width, Cubic Meterage and LengthThese fields are used by Temando or shipping method to calculate shipping cost. These fields have the exact name in Magento.
MI Last Pull updateDate of last inventory update.
MI Out of Stock MessageMessage that can be displayed when the item is out of stock.

Send An Individual Item To Magento

In Netsuite under the Item > Magento Tab tick MI Display in Magento and Enable Product then save. The item will be automatically sent to Magento. In Magento under the Cloud Coders Tab > Queued Jobs From Netsuite you will be able to track the status of the item from Netsuite as it is created as a product in Magento. This item will now be updated automatically in Magento each time an update has been made in Netsuite.

Bulk Importing Netsuite Items To Magento

 Bulk import allows you to sync Netsuite's items that are not yet in Magento. Do not use this feature for updating items already in Magento. Use the Mass update feature instead. 


Step 1. Create a saved search in Netsuite to filter the items you are interested in. Make sure the search is public and available in list view. Set Criteria as required to select the items you want send to Magento.  On the Results tab make sure to include the field "Internal ID".


Step 2. Navigate to Magento > Set-up > Bulk import. Select your saved search from the saved search drop down. From the right select the store you want the products to be assigned to. For multiple stores hold down the "shift" key as you click.

Monitor the progress of updates in Magento under Cloud Coder Tab > Queued Job From Netsuite. While doing a bulk import products may seem to be missing some of their field values. This is because the bulk import brings across item data in several passes. First an initial skeleton item is created with mapped field values updated in a second pass. Note: Do not re run the bulk import until the queue is empty.


Mass Update of Netsuite Items to Magento

A mass update is used when the item already exists in Magento and an update operation has not automatically updated the product in Magento for example a CSV import.

In NetSuite navigate to Lists > Mass Update > Mass Updates


From the "Custom Updates" action select the mass update for the item type to be updated as illustrated below:


Ensure one of the filter fields include "MI Display in Magento" with the value of "yes". Save the mass update or click the "Preview" button. Select "Perform Update" to commence the update, items will start to appear in the queued job from Netsuite option in magento. 

Syncing Item Categories to Magento

Categories maybe added at any time. First they are created in Netsuite, synced to Magento then assigned to items.

Step 1. Create new category using existing functionality in Netsuite. Lists > Website > Categories.

Step 2. Send the Netsuite Categories to Magento. Magento > Set-up > Sync Item Categories


Note: Each time the categories are synced, the Netsuite Categories list in Magento is deleted and then the entire table is rebuilt again. This ensures the structure is always correct. This does not affect the existing mapping.

Step 3. Review the Netsuite Categories in Magento. This will ensure new categories have successfully come across from Netsuite into Magento. Cloud Coders > Netsuite Category


Step 4. Map Categories in Magento

Under Manage Categories, select the Category to be mapped and choose the relevant Netsuite category from the CC Netsuite ID dropdown list.


Step 5. Assign web category to item In Netsuite.

The web category is now ready to be used and can be assigned to an item. Saving the item will automatically send the changes across to Magento.

Items will start to appear on the website once the changes are processed in Magento.