Catalog & Inventory
Importing Products & Ingredients
Bulk-import your product catalog, ingredients, and categories via CSV.
Learn how to bulk-import your product catalog, ingredients (raw materials), and product categories into Stogly using CSV files.
Overview
Stogly supports CSV import for:
- Simple products — items sold directly to customers
- Ingredients (raw materials) — items used in recipes for composite products
- Composite products — items assembled from ingredients via recipes
- Product categories — organizational groups and subgroups
Prerequisites — Import Order
Import data in this order to avoid missing references:
- Categories first — products reference categories by name
- Stores/Warehouses — must exist before importing products with stock quantities
- Suppliers — must exist before assigning preferred suppliers to products
- Ingredients before composite products — recipes reference ingredients by SKU
- Simple products — can reference categories, stores, and suppliers from above
- Composite products — import after ingredients, then set up recipes
> See the Getting Started guide for the full setup dependency chain.
Preparing Your CSV File
Products CSV Format
Your CSV file should include the following columns:
| Column | Required | Description | Example |
|---|---|---|---|
Product Type | Yes | simple, composite, or raw_material | simple |
SKU | Yes | Unique product code | GF-BOX-001 |
Name | Yes | Product name | Lignjun box |
Description | No | Product description | Fresh squid box |
Category | No | Category name (auto-created if not exists) | Porcije - Boxovi |
Cost Price | No | Supplier/cost price | 450.00 |
Selling Price | No | Retail selling price | 1130.00 |
Stock | No | Initial stock quantity | 25 |
Currency | No | Price currency (default: RSD) | RSD |
Unit | No | Unit of measure | kg |
Warehouse | No | Stock location name | GYRO-FISH-01 |
Supplier | No | Preferred supplier name | Morski Plodovi DOO |
Reorder Point | No | Min stock level for alerts | 5 |
Ingredients CSV Format
Use the same format as products with Product Type set to raw_material. Ingredients are used in recipes for composite products and are not sold directly.
Categories CSV Format
| Column | Required | Description | Example |
|---|---|---|---|
Name | Yes | Category name | Porcije - Boxovi |
Parent Category | No | Parent category name for subgroups | Hrana |
Description | No | Category description | Box portions |
Step-by-Step Import Guide
Importing Products
- Navigate to Catalog > Products in the sidebar
- Click the Import button in the toolbar
- Select your CSV file
- Review the Import Preview — the system shows which products will be created or updated
- Click Confirm Import to proceed
- Check the import summary for any errors or warnings
Importing Ingredients
- Navigate to Catalog > Ingredients in the sidebar
- Click the Import button
- Select your CSV file (all items should have
Product Type: raw_material) - Review and confirm the import
Importing Categories
- Navigate to Catalog > Products and click the Categories tab
- Click Import Categories
- Select your categories CSV file
- Categories with a
Parent Categorywill be created as subcategories
Tips & Best Practices
- Stock location: If you don't have a warehouse, use your store name as the warehouse value
- Updating existing products: If a product with the same SKU already exists, the import will update it rather than create a duplicate
- Cost price for ingredients: Always include cost prices for raw materials — these are used to calculate recipe costs for composite products
- Reorder points: Set minimum stock levels to receive low-stock alerts in the notification bell
- Supplier assignment: Including a supplier name links the product to that supplier for purchase order workflows
Troubleshooting
| Issue | Solution |
|---|---|
| Cost price shows as 0 after import | Ensure the column header is exactly Cost Price (with space) |
| Stock not appearing | Verify the warehouse/store name matches an existing location |
| Categories not created | Check that category names don't contain special characters that might cause parsing issues |
| Duplicate products | The system uses SKU as the unique identifier — ensure SKUs are unique |
Need help? Contact support at support@stogly.com