Come together with the global Drupal community in Rotterdam, 28 Sept – 1 Oct 2026. Sessions, contribution, connection, and Early Bird savings until 8 June.
By Durran on
Hi everyone,
Can someone point me in the right direction? At this point im not even sure as to what I need? Let me explain the scenario:
* Im building a Drupal / Ubercart online store.
* I will be drop shipping (blind shipping) products from another distributor (products are in the many thousands)
* The company I will be purchasing from maintains a website with a ftp area that I can log into manually via a web browser and get csv files with stock levels, price updates, and descriptions, etc. etc.
* They manage their stock levels daily.
To get to my point,... how would I maintain these daily updates without manually logging into their ftp area and downloading the csv file(s), modifying it to fit my application, then uploading it to my drupal site via node import or another application / module???
- This seems very confusing to me currently? Im assuming at this point that there is some type of remote database connection or ftp client for drupal / ubercart. Is it even that simple? Is there command line work to be done on my server side, or am I going about this all wrong to begin with? Or can this even be done with Drupal / Ubercart?
I have seen other sites that work in this manner, as a matter of fact I have found another website that does exactly what I am talking about with the same company I am reffering to. I feel I couldnt ask for advice from them as our sites would be in direct competition with one another, so...
- I really hope someone can give me a few helpful pointers on at least where to begin my search.
Thank you Drupal community!!
Comments
Feeds?
Have you looked at all at Feeds? http://drupal.org/project/feeds
I think CSV files with feeds need to be on your server, but you could possibly write a CURL script to fetch the CSV file periodically and store it on your server, then setup Feeds to parse it.
Hmmm, it looks like feeds has
Hmmm, it looks like feeds has some fetchers built in (sorry, I'm not the foremost expert on feeds!), so you might want to poke around there a bit and see what it can offer. If you come up with anything, I'd be interested to hear how you solved this.
So far...
Well,
I have installed feed(s) and have been working with the feed URL. The problem Im running into now is that the feed is behind a "username and password", and I am unsure of what the proper syntax should be?
So far I have tried a few of URL's such as..
ftp://username:password@ftp.site.com/feed1.csv
http://username:password@ftp.site.com/feed1.csv
and
ftp://username:password%40ftp.site.com/feed1.csv
http://username:password%40ftp.site.com/feed1.csv
Any clues as to what my proper values should be to pull from a feed behind a login with password?
Thanks for your help. I think I may be on the right track..
FTP Directory
Try logging in to the FTP site with an FTP program and note the directory that the file you need is in. For example, if the file is located in httpdocs/files the URL would look like this:
ftp://username:password@example.com/httpdocs/files/feed.csv