机器翻译（审校中）。以英文版为准。
NetSuite Inventory Driving Five Ad Channels, With the Return Read in Gross Margin
NetSuite Available-to-Promise, lot age and price tiers drive five ad channels directly: stocked-out SKUs stop spending on the next 15-minute cycle, lots over 90 days move to a clearance variant, and every click-attributed order is read against landed cost and a Day-0 baseline inside the ledger. See the 100x ledger for the rows behind this lever.
Why B2B ad spend and the warehouse disagree
An agency optimizes toward the conversions a platform pixel reports. The pixel does not see Available-to-Promise, FIFO lot age, wholesale price tiers or landed cost, so the account keeps buying clicks to SKUs that stocked out, ignores the pallets that are about to be written down, and reports a return gross of the cost of goods. The CFO sees ad spend in the ledger and a conversion report in a slide deck, and the two never reconcile.
What the bundle installs in NetSuite
| Layer | NetSuite object | What it does |
|---|---|---|
| Inventory feed governor | <code>do_mr_inventory_omnichannel_sync.js</code> (Map/Reduce) | Reads <code>quantityavailable</code>, lot age and price tiers every 15 minutes and on Item Fulfillment and Item Receipt events; pauses a SKU below its safety-stock floor and switches lots over 90 days to a clearance variant across Google, Facebook, Instagram, TikTok and YouTube |
| Feed rules | <code>customrecord_do_dm_sku_feed_rule</code> | Safety-stock floor, aged-lot threshold, price tier and channel status per item |
| Video studio | <code>customrecord_do_dm_video_ad_asset</code> | Renders the SKU photo in the File Cabinet into 9:16, 1:1 and 16:9 motion variants with a three-beat script and Google RSA copy checked to 30 and 90 characters |
| B2B checkout | <code>do_rl_b2b_instant_purchase.js</code> (RESTlet) | Creates the Sales Order or Cash Sale from the ad click: card, ACH or an approved Net-30 PO, the FIFO lot reserved for 24 hours, the click token written to the transaction |
| Attribution | <code>do_ue_so_campaign_attribution.js</code> (User Event) and <code>customrecord_do_dm_sales_attribution</code> | Joins <code>transactionaccountingline</code> landed cost to each attributed order and posts spend, revenue and gross profit by channel |
| Baseline and ledger | <code>customrecord_do_dm_campaign_ledger</code> and <code>do_sl_marketing_roi_cockpit.js</code> (Suitelet) | Snapshots the trailing 90 days before the first impression and reports incremental gross profit against it |
How a campaign runs
- Day-0 baseline. Before any ad is live, the bundle writes the trailing 90 days of sales by SKU, subsidiary and customer cohort to the campaign ledger. Every later figure is measured against this snapshot.
- Feed. The Map/Reduce syndicates each advertised SKU with its current ATP, lot age and price tier. When a pick takes ATP below the floor, the SKU’s ad groups pause on that cycle; when stock returns they resume.
- Creative. The studio renders each SKU photo into the three ratios with the stock count and price tier in the copy, and regenerates the variant when the SKU moves to the aged-lot rule.
- Order. The ad lands on a checkout that posts to the RESTlet. The Sales Order or Cash Sale is created with the lot reserved, the price tier applied and the click token on the transaction.
- Return. The User Event joins landed cost and writes the attribution record. The Suitelet reports gross profit by channel against the baseline; the figure the CFO sees is the one in the ledger.
What the bundle does not claim
- It does not forecast your lift. The simulator on the offer page is arithmetic on your own spend, baseline and margin inputs, and says so.
- It does not replace your web store, portal or EDI flows. The checkout exists for ad clicks.
- It does not spend on your behalf. Ad budgets stay in your platform accounts; the bundle changes what they advertise and reads what they earned.
常见问题
Which ad platforms does the feed reach?
Google Ads (Search RSA and Performance Max feeds), Facebook and Instagram catalog and Reels placements, TikTok and YouTube. Each channel receives the same ATP, lot-age and price-tier fields; the creative ratio differs by placement.
How is the return measured if a buyer sees the ad but orders through a rep?
Only orders that carry a click token are attributed, so a rep-entered order without one counts toward the baseline comparison but not toward a channel. The read is deliberately conservative: it understates the campaign rather than crediting it with sales it cannot tie to a click.
What does it cost and how long does it take?
$15,000 flat for the SDF bundle and feed setup, then $2,500 per month to run the engine, delivered in 14 days from account access with about three hours of your time. Ad spend is separate and paid to the platforms from your accounts.
Does this need NetSuite SuiteCommerce?
No. The checkout is a RESTlet landing page and the records are standard custom records; the bundle deploys through SDF to any NetSuite account with inventory items and the SuiteScript features enabled.
相关研究
CFO and CMO Dialogue: Ad Spend Read in Gross Margin, Not in a Pixel
A CFO who will not approve ad spend he cannot reconcile, a marketing lead with 1,800 SKUs and no video, and a COO with two lots past 90 days ask how a NetSuite SDF bundle feeds five ad channels from live ATP, renders SKU photos into video, posts the order with the lot reserved, and reports the return against a Day-0 baseline in realized gross margin.
COO对话：装卸月台拥堵与货运罚款
一位COO正面临卡车排队和承运商重新称重罚款的问题。Kyle展示了货叉秤和直接ZPL热敏打印如何消除静态秤停靠环节，并绕开昂贵的第三方WMS软件。
车间主管对话：秤、扫描枪与FIFO子记录
一位资深叉车司机讲述消费级平板为何在15F的冷冻库中死机。Kyle介绍了加热型车载终端、免持戴式指环扫描枪，以及在拣错货时向司机发出提醒的自动化子记录FIFO批次锁定。
直接与架构师沟通，而非销售人员
面向NetSuite的Aissistor技术：企业为五个角色付费，现由一个受管控的盒子承担，建模成本降低20-80%，现有团队转岗而非替换，每项成果均在100x时间台账中公布并标明来源类别。
Scope the B2B Inventory Ad Bundle 阅读100x台账
The direct email and phone number are shared in the receipt of a verified request.