Product master data
Product master data is the canonical list of what you sell — your SKUs, the bundles you’ve built from them, the ASINs they map to, and the attributes (cost, dimensions, brand, category) Hilal uses for forecasting, fee analysis, and reporting.
In this guide:
- Open the Products view
- Search and sort products
- Track COGS
- Assign suppliers and manage costs
- View product details
- Use attributes for downstream features
Prerequisites
- Amazon Seller account connected.
Step 1: Open the Products view
Go to Inventory → Master Data in the sidebar.
The list shows all products (SKUs) from your connected Seller account.
Step 2: Search and sort products
Use the search bar to find products by title, ASIN, SKU, or brand.
Sortable columns include:
- Product name
- SKU / ASIN
- FBA stock quantity
- Price
- Units sold
- Sales, profit, margin, ROI
Click any sortable column header to sort ascending or descending.
Filter and view options:
- Hidden toggle — show or hide products you’ve marked as hidden from the default view.
- View by dropdown — group products by Product, Supplier, Warehouse, Brand, or Marketplace.
- Channel dropdown — filter by fulfillment channel (All, FBA, or other channels).
Step 3: View product details
To view detailed product information, go to Inventory → Inventory (not Master Data) and click a product title. This opens the product detail page with these tabs:
- Overview — general product information and current stock levels.
- Forecast — demand forecast for this product.
- Orders — recent purchase orders for this product.
- Fees — Amazon fees calculated for this product.
- Settings — supplier assignments and product-specific configuration.
Step 4: Track cost and COGS per SKU
The master-data page displays a COGS column (Cost of Goods Sold) for each product. This field powers profitability calculations across Hilal:
- COGS — the weighted cost across your current inventory for this product, calculated from the individual batches you’ve recorded and their cost allocations.
To track COGS over time and understand your cost basis, you can bulk import product cost history:
- Go to Settings → Bulk Export/Import.
- Select the Upload (Import) tab.
- Choose Products from the entity dropdown.
- Upload a spreadsheet with product cost data.
- Review the preview and validation results.
- Watch the import progress and see the results in the Previous Imports list.
Step 5: Assign suppliers and track costs per unit
To manage suppliers for a product and set supplier-specific costs, go to Inventory → Inventory and locate the Suppliers column. Click the + button next to a product to open Manage suppliers:
- Add supplier — search and select from your vendor list.
- Set primary — mark one supplier as the default for PO generation.
- Cost per unit — enter what this supplier charges. This is separate from your inventory COGS.
Step 6: Use attributes for downstream features
The attributes you set here power features elsewhere:
- Cost drives the profit column in the dashboard and the P&L report in Finances.
- Dimensions / Weight drive the Amazon fee analyzer and the FBA shipment builder’s pallet estimation.
- Brand / Category are filters in Analytics & trends and dimensions in Superset BI dashboards.
- Image appears in lists, the dashboard’s top-SKUs card, and exported reports.
Investing in clean master data on day one pays off everywhere.
Troubleshooting
- A product’s cost is missing. Assign a supplier in the Inventory → Inventory list (Suppliers column) and set the cost per unit.
- COGS looks wrong. Check that all suppliers have accurate cost-per-unit values assigned.