1.09 Importing products from a CSV file
26.12.2018
Support Wissensdatenbank
Du bist hier:
- KB Home
- ShopDesigner
- General information
- 1.09 Importing products from a CSV file
Import CSV file
Importing products from a CSV file is ideal for importing large quantities of products or even updating the inventory of your existing products.
To import products:
- Click on Shop
- Click on Product Import
To import your products, upload your CSV file. Further information about the headers used in the CSV can be found on the product import page under IMPORT: SO GEHT’S. There is also an example CSV available on this page if you want to know how to structure the CSV file.
Notes on this function:
- The first row in the CSV is reserved for the header columns. These must be in the correct order and spelling.
- The file must be saved in CSV format (.csv)
- The main product ‘Handle’ (which contains all product information, title, long name etc.) must appear in the CSV before one of your variation lines.
- For each group of products ‘Handle’, the import updates the product if the handle already exists, or creates a new one if the handle has not yet been imported.
- SKU’s must be unique. Creating a new product with an existing SKU therefore causes the import to cause an error.
- Images must have a valid URL.
- Tags’,’Option Names’ and ‘Option Values’ must be separated by semicolons.
- Visible’,’Stock Track’ and’Stock Unlimited’ must be set to ‘yes’ or ‘no’.
- Option Values’ and ‘Option Names’ must have the same number of entries.
War dieser Artikel hilfreich?
0 out of 5 stars
5 Stars | 0% | |
4 Stars | 0% | |
3 Stars | 0% | |
2 Stars | 0% | |
1 Stars | 0% |
-
- Add user
- Cancel a contract
- Change address data
- Change contact person (company)
- Change password
- Display bills
- Invoice by mail
- Manage Partner Access
- Password Forgotten
- Payment methods
- Payment slip
- Product Transfer
- Reminder
- Setting up two-factor authentication
- Top up credit
- Webmail Link
- Zeige alle Artikel ( 1 ) Artikel ausblenden
-
- Activate Whois Privacy
- Cancel domain
- Change contacts
- Change DNS entries
- Change DNS Server
- Check DNSSEC
- Connect website to Squarespace
- Connect website with Wix
- Connect your website to Jimdo
- Difference in domain redirect
- DNSSEC
- DNSSEC Deactivate
- Domain Forwarding
- Extend domain
- Google Optimization
- Google search optimization
- Google SiteVerification
- Link domain
- Questions about the domain
- Search engine registrationa
- Transfer domain
- Zeige alle Artikel ( 6 ) Artikel ausblenden
-
- Are our e-mails encrypted?
- Automatic e-mail reply
- Change password
- Distribution lists Office 365
- Exchange Konto übertragen
- external name servers
- JUNK Mail in Outlook
- Newsletter Server important questions
- Office365 Logout and Setup
- Report SPAM Mails
- Send e-mails
- Send email as attachment
- Set up email alias
- Setting up an email account in Thunderbird
- SPF entry
- Webmail Link
- Webmail Login does not work
- Zeige alle Artikel ( 2 ) Artikel ausblenden
-
-
-
- Add module PGSQL in PHP
- Change IP at Confixx
- Confixx 3.1 End User Manual
- Confixx 3.1 Special Edition Manual for Administrators
- Confixx Server DBD::mysql or other PERL module displays error message
- Release Confixx database
- Setting up Apache server compression in Debian
- Setting up Apache server compression in SuSE
- Swap Confixx license
-
- Apache2 does not start
- Automatic detection with Plesk Server (Linux)
- Create customer in reseller hosting
- LINUX: Apache Crash at log rotation at UBUNTU
- LINUX: MySQL Upgrade von 5.5 auf 5.6 mit Ubuntu
- Linux: Restart Network Interface
- Linux: Too many open files in Ubuntu
- Plesk can't start PHP-fpm
- Plesk Linux: Enable NGINX and HTTP/2
- Plesk Log Files
- Repairing databases
- Special character problems
- Upgrade MSSQL Server
- Use PHP version
- Allow Support Team Access
- Empty directory quickly
- Enlarge partition at Ubuntu 16.04
- How do I log in via SSH?
- Monitoring of RAID controllers
- Optimize your server
- Questions about the root servers
- restore very old website
- SNF filter does not start
- Start NGINX manually
- Ubuntu remove old kernel
- Windows Server 2019 Change language
- WordPress installieren
-
-
-
-
- 1.00 The most important questions about ShopDesigner
- 1.01 Set up your online shop
- 1.02 Add products to your online shop
- 1.05 Product categories and keywords
- 1.06 Inventory and Inventory Tracking
- 1.07 Shipping options
- 1.08 Tax rates
- 1.09 Importing products from a CSV file
- 1.10 product variants
- 1.11 AGB for your OnlineShop
- 1.13 Set currency
- 1.16 OnlineShop Analysis
-
-
-
- 01 Adding and moving content
- 02 Colors and fonts
- 03 Website designs
- 04 Use a stock image
- 05 change an image
- 06 Add page
- 07 Set up a store
- 09 Site analytics
- 1.01 SiteDesigner Quickstart
- 1.02 Add basic page information
- 1.03 Change the appearance of your page
- 1.04 Pictures, Galleries and Presentations
- 1.05 Text and headings
- 1.09 Hide incomplete pages
- 1.10 Forms, cards and other content
- 1.11 Setting Language, Currency and Units
- 1.14 Re-sort and rearrange pages
- 1.15 SiteDesigner Mobile and mobile phone quick start
- 1.16 SiteDesigner Tablet Quickstart
- 1.17 How does the Template Editor work?
- 1.20 Undo changes
- 1.22 Setting up a user-defined contact form
- 10 Setup a blog
- 12 Multiple language sites
- 15 Contact forms
- add more pages to SiteDesigner
- Add number of pages to my page
- Add type of content to my website
- Advantage of SiteDesigner
- Definition SiteDesigner
- Edit Site Template CSS
- Edit SiteDesigner with HTML code
- Export page from SiteDesigner and send it to another server via FTP
- Page good ranking?
- pay by phone with credit card
- Request Backup
- Request emergency service
- SiteDesigner Move Package
- Take website offline
- Webhosting to the SiteDesigner?
- Zeige alle Artikel ( 25 ) Artikel ausblenden
-
- Activate SSL certificate
- Activate SSL certificate for forwarding
- Browser is not supported
- Certification Requirement (CSR)
- Conditions to be fulfilled
- Creating a Certification Requirement (CSR) for Apache
- Definition SSL CERTIFICATE
- Difference Domain and Identity Certification
- Intermediate certificate
- Requirements for issuing an SSL Certificate
- SiteSeal
- the right certificate
- Wildcard certificate
-
-
-
-
- Customizing the domain of a Wordpress website
- Increase PHP timeout
- load-scripts.php 500 Internal server error
- Permalinks in Wordpress (Windows)
- Rename URL
- Switch off Wordpress maintenance mode
- Transfer Wordpress Website
- WordPress - Login button is not displayed
- Wordpress login doesn't work, password reset doesn't work either
- xml-rpc.php Forbidden
-