• Get started
  • Newsletter
  • Categories
    • Online shop & ecommerce
    • Shop Design
    • Marketing
    • Search engines (SEO)
    • Products
    • Payment & Delivery
    • Legal issues
    • Merchant stories
  • Search
  • Menu Menu
Sarah Böhm

Import / Export: Managing Store Data Offline

9. May 2008/0 Comments/in Online shop & ecommerce /by Sarah Böhm

Import-ExportPrices change and stock data have to be maintained – if the product range is relatively large, processing data in the store management feature may take some time to complete. This is quicker and more clearly arranged offline, for example, with MS Excel.

Data can be transferred from the store management feature to an offline document or from an offline document to the store management feature in Products -> Import and Export.

1. Export.To export data select the desired data and its display form from the drop-down menus.
Clicking on the ‘Export’ button generates a file which can be edited and saved locally on your hard drive.
Note: If you have enabled a download blocker for your browser, you will need to activate the download to save the file. Export files end in the extension *.csv. CSV stands for Comma Separated Value. This format is understood, for example, by MS Excel.

When it is launched Excel automatically sorts the values into columns. If this is not the case, change the separator from semicolon to comma. Data processing in Excel: Leave the information in the first row unchanged as far as possible and do not add any new columns. You can alter the cells and even add new cells in all of the other rows. Even the order of the columns can be changed. This provides all of the data in a clearly arranged format and it enables you now to implement percentage price increases, make changes to product designations and much more by making just a few entries.

Special features in Excel: Excel has some automatic features, which unfortunately cannot be turned off. If, for example, you have entered a value of "1.5" for a product attribute in the store and then view this in Excel, Excel automatically converts the entry to "01 May ". This can only be prevented by formatting the respective cell or the entire column as text. Note: Save the file again in Excel with the extension .csv (not .xls!).

2. Import. If you just want to launch the store and use the data import feature, first create a few products and categories in the store manager and then export these. Use the resulting CSV file as a template for future use. To import a file into the store manager simply upload it under Import and Export and then click on Import.

Sarah Böhm
+ posts

Als Content Manager bei ePages ist Sarah für redaktionelle Inhalte und Videocontent zuständig. Im ePages-Blog stellt sie Onlinehändlern Marketingtipps, rechtliche Updates und Infos zur ePages-Software zur Verfügung, um ihnen den Einstieg in den E-Commerce zu erleichtern.

  • Sarah Böhm
    https://blog.epages.com/en/author/sboehm/
    Low effort, maximum performance: boost your online marketing with AI tools
  • Sarah Böhm
    https://blog.epages.com/en/author/sboehm/
    5 success factors for Black Friday and Cyber Monday 2022
  • Sarah Böhm
    https://blog.epages.com/en/author/sboehm/
    How to create your online payment portfolio with Mollie
  • Sarah Böhm
    https://blog.epages.com/en/author/sboehm/
    Boost your SEO with these ranking factors for 2022 and beyond
Tags: Data Export, Data Import
Share this entry
  • Share on Facebook
  • Share on WhatsApp
  • Share on LinkedIn
  • Share by Mail
https://blog.epages.com/wp-content/uploads/2021/07/replace2-1.png 64 64 Sarah Böhm https://blog.epages.com/wp-content/uploads/2021/11/logo-epages-blog.svg Sarah Böhm2008-05-09 14:12:012022-01-12 12:17:50Import / Export: Managing Store Data Offline
0 replies

Leave a Reply

Want to join the discussion?
Feel free to contribute!

Leave a Reply Cancel reply

You must be logged in to post a comment.

Search posts

Recent posts

  • Low effort, maximum performance: boost your online marketing with AI tools
  • Fine-tune marketing for your shop with FAQs, design templates, tracking and other features
  • Performance Max campaigns, product numbers, accounting apps and more: New features for ePages Now
  • 5 success factors for Black Friday and Cyber Monday 2022
  • How to create your online payment portfolio with Mollie

Categories

  • ePages Direct
  • Legal issues
  • Marketing
  • Merchant stories
  • Online shop & ecommerce
  • Payment & Delivery
  • Products
  • Search engines (SEO)
  • Shop Design
  • Success stories
  • Uncategorized

Tips for a successful start in e-commerce

Checklist: how to start your online shop
Sources for product ideas the ultimate list
Product photos avoiding common mistakes
The best category structure for your shop
Content marketing strategies for your online shop
The 6 key elements of a good seo strategy

ePages blog newsletter

ePages blog newsletter

© 2023 ePages · Pilatuspool 2 · 20355 Hamburg · Deutschland

Contact ·  Terms & Conditions  · Legal Notice · Data Privacy Protection

  • English
    • Français (French)
    • Deutsch (German)
    • Español (Spanish)
Scroll to top