Europa sports datafeed ftp www europadatafeed com
This presentation is the property of its rightful owner.
Sponsored Links
1 / 14

Europa Sports Datafeed ftp://europadatafeed PowerPoint PPT Presentation


  • 49 Views
  • Uploaded on
  • Presentation posted in: General

How to import Europadatafeed.csv. Europa Sports Datafeed ftp://www.europadatafeed.com. www.europasports.com. Step 1: access the ftp. The ftp is a folder of information. Here is a brief screenshot of our FTP site, europadatafeed.com. Notice that it is not http, it is ftp. Step 1 continued.

Download Presentation

Europa Sports Datafeed ftp://europadatafeed

An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -

Presentation Transcript


Europa sports datafeed ftp www europadatafeed com

How to import Europadatafeed.csv

Europa Sports Datafeedftp://www.europadatafeed.com

www.europasports.com


Step 1 access the ftp

Step 1: access the ftp

  • The ftp is a folder of information. Here is a brief screenshot of our FTP site, europadatafeed.com. Notice that it is not http, it is ftp.


Step 1 continued

Step 1 continued

  • Once you determine you are using csv, you have 3 options, 2 of which go together.

  • datafeed_v1_2.csv is the first version of the datafeed in csv. It does not have nutrients.

  • DF_Nutrients_2_0.csv is part one of version 2 of the csv. You will combine this with DF_Products_2_0.csv

  • Use either an ftp client like Filezilla or download the file locally using the web browser.


Step 2 starting the import into excel

Step 2, starting the import into Excel

  • Excel is a great program to use for CSV files, but it not the best choice. CSVed is probably the best program to use with csv. Excel does fine for most people.

  • Start with a new, blank workbook. Go to the start menu in the corner


Step 2 continued

Step 2 continued

  • Click Data, then select from Text


Step 2 continued1

Step 2 continued

This is where you will open your locally saved copy of the feed.


Step 3 text import wizard

Step 3: text import wizard

Once you open the file, a dialog box will open:


Step 4

Step 4

The dialog box will automatically select Fixed width. We want to change it to “Delimited”


Step 5

Step 5

  • Once Delimited is selected, hit “next” at the bottom of the dialog box:


Step 6 selecting the type of delimitation

Step 6, selecting the type of delimitation

  • Tab may be auto selected. Uncheck the box next to “Tab” and select “Comma” since this is CSV (comma separated value)


Step 7 selecting all the data

Step 7, selecting all the data

  • The next screen will ask you how to format the data. Holding the “shift” key, move the bottom navigation arrow all the way over to the right, and click the top of “general” tab


Step 7 continued

Step 7 continued

  • Once all the data is selected, click “text” then finish


Finished

Finished!

  • The database should populate the spreadsheet with the proper formats, including the leading “0 (zero) on manufacturers that start with 0.

  • UPC will also properly format.


Setting up an online profile and using the dashboard

Setting up an online profile and using the dashboard

  • Thank you for being our customer and of course any time you need assistance, email us or call us.

  • 800-447-4795 xt 1272

  • [email protected] (account set up) Web Sales Coordinator

  • [email protected] (Customer Service) They are available to assist with order history and tracking.

  • [email protected] (a mix of both)

  • We hope this has provided useful information!


  • Login