Requirement:
Perform a comprehensive analysis to assess the feasibility and approach for delivering a structured product data feed (preferably in XML format) from NetSuite, enabling a third-party customer to list Bastion products on their external eCommerce platform. In parallel, analyze the existing Product Feed field within the item records to understand its intended use, configuration, and potential relevance to the integration.
Solution:
๏ปฟTo calculate the estimate for exporting a product feed as a custom CSV using the SuiteCommerce Product Feeds extension, weโll break down the process into each required step and assign realistic time estimates for each activity.
๐ง Step-by-Step Breakdown with Time Estimates
1. Pre-requisites Check (Features & Provisioning)
- Verify required NetSuite features are enabled.
- Ensure SuiteCommerce Product Feeds extension is provisioned.
๐ Estimated Time: 30 minutes
2. Install the SuiteApp
- Navigate to Customization > SuiteBundler > Search & Install Bundles.
- Search, verify, and install SC Product Feeds SuiteApp.
๐ Estimated Time: 20 minutes
3. Update Item Records
- Either manually, using Mass Update, or CSV import to populate product feed fields.
- Mass Update (standard use case):
- Create and configure multiple mass updates depending on item types and field count.
๐ Estimated Time: 1โ2 hours, assuming 2โ3 iterations for different field sets.
4. Create Product Feed Record
- Navigate to Lists > Feeds > Product Feeds > New.
- Configure name, feed type (custom CSV), website, domain, saved search, and custom CSV export settings.
๐ Estimated Time: 30 minutes
5. Create or Modify Saved Search
- Use default template, adjust columns (feed attributes), and filters for your custom CSV.
๐ Estimated Time: 1 hour
6. Generate the Product Feed
- Initial generation can take up to 1 hour for large catalogs.
- Download and verify output.
๐ Estimated Time: 30โ60 minutes
๐งฎ Total Time Estimate
Task
Time
Pre-requisites Check
30 mins
SuiteApp Installation
30 mins
Update Item Records
6h
Update Matrix Items
3h
Create Product Feed
1h
Configure Saved Search
1h
Generate & Validate Feed
1h
Total
13h
Dev – 13h
QA – 3h
PM – 2h
Analysis – 6h
Total – 24h