HomeBulk import and update of new product listingsInventory & Product ManagementBulk import and update of new product listings

Bulk import and update of new product listings

Purpose

1.1. Enable bulk import and update of aeromodel product listings across multiple platforms, automating SKU creation, updating prices, stock, images, descriptions, metadata, and categorization using various integration endpoints and formats (CSV, XLSX, XML, API payloads).
1.2. Centralize inventory management workflows, ensuring all retail channels and back-office systems reflect the same product catalog instantly with minimal manual input.

Trigger Conditions

2.1. Detection of new product file upload in secured cloud storage (e.g., Google Drive, Dropbox, S3 bucket).
2.2. Scheduled polling of supplier databases or APIs for catalog changes.
2.3. Direct HTTP/Webhook notification from external supplier or vendor systems.
2.4. Manual form submission or drag-and-drop action in the POS or admin dashboard.

Platform Variants

3.1. Shopify
• API: Product Creation & Update (REST Admin API)
• Example: /admin/api/2023-01/products.json POST for new listings; PUT for updates.
3.2. WooCommerce
• API: Products Endpoint (REST API v3)
• Example: /wp-json/wc/v3/products POST/PUT, authentication with Consumer Key/Secret.
3.3. Magento
• API: CatalogProductRepositoryV1 (SOAP/REST API)
• Example: POST /rest/V1/products for import; PUT for updating.
3.4. BigCommerce
• API: Catalog Products (v3 REST API)
• Example: POST /stores/{store_hash}/v3/catalog/products.
3.5. Salesforce Commerce Cloud
• API: Product Import Pipeline & OCAPI Product resource
• Example: /s/-/dw/data/v21_3/products (OCAPI).
3.6. Lightspeed Retail
• API: Product API Endpoint
• Example: POST /API/Account/{account_id}/Product.json.
3.7. PrestaShop
• API: Products Webservice
• Example: POST /api/products, XML body.
3.8. Amazon Seller Central
• API: Amazon Marketplace Web Service (MWS) or Selling Partner API
• Example: SubmitFeed operation with _POST_PRODUCT_DATA_.
3.9. eBay
• API: Inventory API
• Example: POST /sell/inventory/v1/inventory_item for each SKU.
3.10. Wix Stores
• API: Wix Stores Products API
• Example: POST '/v1/products', passing API key in header.
3.11. Squarespace
• API: Commerce Products API
• Example: PATCH request for updates to /commerce/products/{id}.
3.12. OpenCart
• API: Product API (REST/OCMOD)
• Example: POST /api/rest/products for new import.
3.13. SAP Commerce Cloud (Hybris)
• API: Product Webservices
• Example: POST /rest/v2/{baseSiteId}/products.
3.14. Google Merchant Center
• API: Content API for Shopping
• Example: products.insert method via JSON.
3.15. QuickBooks Commerce
• API: Products Endpoint
• Example: POST /products to set new item.
3.16. Zoho Inventory
• API: Items Module API
• Example: POST /api/v1/items with integration key.
3.17. NetSuite
• API: SuiteTalk (SOAP/REST)
• Example: addList operation for InventoryItems.
3.18. Odoo
• API: JSON-RPC Product Creation
• Example: call model.product.product.create.
3.19. Linnworks
• API: Inventory Item Create/Update
• Example: Call Inventory/CreateInventoryItem, update with Inventory/UpdateInventoryItem.
3.20. Vend POS (Now Lightspeed)
• API: Products Endpoint
• Example: POST /api/2.0/products, Bearer token in header.

Benefits

4.1. Accelerated product onboarding, scaling to thousands of SKUs in minutes.
4.2. Elimination of manual data entry errors and duplicate catalog entries.
4.3. Consistent, synchronized data across all sales channels and back-office.
4.4. Rapid reaction to pricing, stock, and regulatory changes.
4.5. Enables dynamic pricing, multi-location inventory, and data-driven merchandising.
4.6. Supports compliance with product feed formats of advertising networks.
4.7. Spend less IT resources on repetitive batch updates.
4.8. Increases agility for new product launches in the aeromodelling segment.

Leave a Reply

Your email address will not be published. Required fields are marked *