Guides and How-to's
Step-by-step guides and how-to articles for getting data into your store: importing products and customers, AI-assisted column mapping, scheduled imports from URL or FTP, Google Sheet–to–store sync, and troubleshooting common file import issues.
We recommend File2Cart for file-based import and scheduled feeds and Sheet2Cart for Google Sheet sync. Use our homepage to choose the right tool, then follow these guides to set up and run imports with confidence.
What you'll find
- Import basics: First-time setup, connecting your store, and uploading CSV or Excel
- Column mapping: Matching file columns to product, variant, and inventory fields—with AI suggestions
- Scheduled sync: URL, FTP, and Google Sheets as recurring data sources
- Platform-specific: Shopify, WooCommerce, Wix, BigCommerce—see our platform guides for more
- Troubleshooting: Validation errors, format issues, and common import fixes
Calculating True Profit for Print-on-Demand: Beyond the Surface Margin
Uncover the real profitability of your Print-on-Demand products. Learn to meticulously track hidden costs like fees, shipping, advertising, and refunds to ensure sustainable e-commerce scaling.
Seamlessly Selling Physical and Digital Products in One Online Store
Discover how to effectively manage and sell both physical goods and digital downloads from a single ecommerce platform. Learn configuration, best practices, and strategic advantages for a hybrid store.
Unlocking Sales Insights: How to Identify Your Top-Selling Products from Manual Records
Transform manual sales logs into actionable insights. Learn how to standardize data, use pivot tables, and identify your most popular and profitable products for better business decisions.
Mastering Regex for Ecommerce: Taming Semi-Structured Product Data
Learn how to use regular expressions (Regex) to efficiently extract and clean semi-structured product data in spreadsheets, overcoming challenges like greedy matching for your ecommerce catalog.
Navigating UK to EU Import Taxes: A Comprehensive Guide for Ecommerce Sellers
Understand and communicate UK to EU import taxes effectively. Learn about the €150 customs duty threshold vs. universal VAT, and strategies to prevent customer dissatisfaction for your online store.
Unlocking Organic Growth: A Strategic Guide to Promoting Your Online Store
Discover data-driven strategies for promoting your online store beyond personal networks. Learn to master SEO, leverage social media, and optimize product data for sustainable growth.
Preserving Precision: Tackling E+15 Errors in Your Ecommerce Spreadsheets
Learn how to prevent and fix E+15 scientific notation errors in Google Sheets and other spreadsheets, ensuring the accuracy of your ecommerce product IDs, SKUs, and inventory data.
Strategic Breaks: Managing Your Online Store During Temporary Absences
Learn the best strategies for managing your online store during a temporary absence, including vacation mode, extended shipping times, and selective listing deactivation, to protect your sales and search ranking.
Mastering Your Product Catalog: Identifying Duplicates Across Google Sheets
Learn how to efficiently identify duplicate product entries across multiple Google Sheets using conditional formatting and advanced formulas. Essential for clean ecommerce catalog management.
Mastering Data Cleanup: Extracting Names in Google Sheets for E-commerce Efficiency
Learn how to efficiently extract and reformat names (last name, first initial + last name) from your e-commerce data using powerful Google Sheets formulas. Streamline your catalog, customer, and supplier management.