Close

Results 1 to 8 of 8
  1. #1
    DF Super Moderator
    DejaVu's Avatar
    Join Date
    Nov 2005
    Location
    Suffolk
    Posts
    9,142
    Thanks
    1,867
    Thanked:        4,072
    Karma Level
    994

    Help Excel Guru's required - Live CSV for Stocklist of a website.

    A mate of mine is setting up a dropshipping website and has asked me to look into creating something that will help keep his stocklist upto date with his suppliers.
    Not ever done it this way before and I'm not even sure its possible (but I'm a strong believer of anything is possible), so thought I'd ask the you lads here on DF.

    This is what needs to happen (sort of).

    Live CSV with Stock/Cost Price/Product Name
    @ [Only registered and activated users can see links. ]
    ----->
    ----->
    Conversion Occurs
    (Live CSV on SkyDrive or Google Drive Perhaps)
    ----->
    ----->
    Required format for his sites Import CSV.

    I was thinking 3 Sheets in a live Spreadsheet, the first being imported from the Live CSV (will this change as the Suppliers stock changes though?).
    Conversion would be quite simple using the likes of =Sheet1!A2 in the appropriate place to correspond with what's need in the sites backend import.
    Sheet 3 would then be the CSV required by his Live rebranded site.

    Am I completely off-track, in dreamland and with no idea about how this'll work?
    Quite possibly... but does anyone care to point out what and why it won't work and if a better solution is possible?

    Still waiting for the Live list from suppliers to find out, but thought you guys might know before I tried to bother.


  2. #2
    DF Jedi akimba's Avatar
    Join Date
    Jun 2006
    Location
    UK
    Posts
    3,025
    Thanks
    1,152
    Thanked:        839
    Karma Level
    341

    Default Re: Excel Guru's required - Live CSV for Stocklist of a website.

    I am an Excel Guru but I don't understand what you are trying to do :-(

    I am guessing you get the live stock from supplier and you want to clean/convert it to be imported into website.

    This can be done but it will take manual intervention i.e. click button in excel to start the conversion.

    What about new products and does he need validation or is the web import process robust, I am guessing it has id's for products so cant just load them in any old order?

  3. #3
    DF Super Moderator
    DejaVu's Avatar
    Join Date
    Nov 2005
    Location
    Suffolk
    Posts
    9,142
    Thanks
    1,867
    Thanked:        4,072
    Karma Level
    994

    Default Re: Excel Guru's required - Live CSV for Stocklist of a website.

    Quote Originally Posted by akimba View Post
    you get the live stock from supplier and you want to clean/convert it to be imported into website.
    Spot on.

    Quote Originally Posted by akimba View Post
    What about new products and does he need validation or is the web import process robust, I am guessing it has id's for products so cant just load them in any old order?
    Each product has it's own 6-8 digit ID is all I know so far (still waiting for the Live List from Supplier).
    New products will be added manually to his site, but updated by the Live CSV for Stock and Cost Price.
    The site was created by VisualSoft and they assure us it's a robust import - they're just a bit shit with communicating any worthwhile information with us.

    The suppliers CSV is going to be completely different to the one required for import, we are just hoping to simplify the process, instead of having to import a CSV everyday to keep it up to date.
    Being over 3,000 products is going to be a PiTA to do everyday.
    Last edited by DejaVu; 14th July 2014 at 04:43 PM.


  4. #4
    DF Super Moderator Over Carl's Avatar
    Join Date
    Apr 2006
    Location
    London
    Posts
    13,239
    Thanks
    4,381
    Thanked:        1,809
    Karma Level
    1328

    Default Re: Excel Guru's required - Live CSV for Stocklist of a website.

    I would forget this idea and instead look into a back end database.

    It's been a very long time since I did this so I forget the details but access, adodb and asp spring to mind.

  5. #5
    DF Jedi blacksheep's Avatar
    Join Date
    Jun 2006
    Location
    Manchester
    Posts
    3,877
    Thanks
    87
    Thanked:        265
    Karma Level
    517

    Default Re: Excel Guru's required - Live CSV for Stocklist of a website.

    As with over carol you need something with state control and spreadsheets aren't going to cut it with,ultiple users - relational database is the way to go.

  6. #6
    DF Jedi Zoots's Avatar
    Join Date
    Oct 2010
    Location
    Hoth
    Posts
    3,329
    Thanks
    1,648
    Thanked:        1,322
    Karma Level
    398

    Default Re: Excel Guru's required - Live CSV for Stocklist of a website.

    Quote Originally Posted by blacksheep View Post
    over carol
    snigger

  7. #7
    DF Jedi blacksheep's Avatar
    Join Date
    Jun 2006
    Location
    Manchester
    Posts
    3,877
    Thanks
    87
    Thanked:        265
    Karma Level
    517

    Default Re: Excel Guru's required - Live CSV for Stocklist of a website.

    Name used at weekends

  8. #8
    DF Jedi akimba's Avatar
    Join Date
    Jun 2006
    Location
    UK
    Posts
    3,025
    Thanks
    1,152
    Thanked:        839
    Karma Level
    341

    Default Re: Excel Guru's required - Live CSV for Stocklist of a website.

    If the Stock files from all suppliers are in the exact same format get an import routine created to import these.

    Updating the stock maybe a mundane thing to do but depending on volume sometime mundane things pay, if I was making x thousands a day I wouldn't mind importing a few files a day for that.

Similar Threads

  1. [HELP] Excel help required please!
    By DJ Overdose in forum The Dog and Duck
    Replies: 5
    Last Post: 25th March 2015, 12:34 AM
  2. [HELP] Excel Guru required
    By DejaVu in forum PC Software
    Replies: 10
    Last Post: 27th April 2011, 01:17 AM
  3. Blackberry Guru Required!
    By DejaVu in forum Android Phones & Tablets
    Replies: 24
    Last Post: 27th October 2010, 09:56 PM
  4. Photo Guru required
    By TIN CAN in forum Your Photos & Artwork
    Replies: 12
    Last Post: 4th December 2009, 10:58 PM
  5. PS7 replicating images GURU required
    By Shambles in forum PC Software
    Replies: 3
    Last Post: 12th May 2005, 12:18 AM

Social Networking Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •