Results 1 to 15 of 15

Thread: Keeping leading zeros

  1. #1
    Join Date
    Feb 2013
    Posts
    118

    Default Keeping leading zeros

    Hi,

    Does anyone know how to ensure leading zeros are retained when exporting product data as a csv file? There is an option to keep/ignore leading zeros on product import but nothing for export.
    At the moment whenever I export my product list it removes leading zeros which is a real pain.

    Thanks,
    Paul

  2. #2
    Join Date
    Oct 2009
    Location
    Nottingham
    Posts
    2,566

    Default

    You can use the "custom" option in the cell format of Excel to put them back on.

    Can't see how to do it with BP export.

  3. #3
    Join Date
    Aug 2007
    Posts
    2,516

    Default

    The file exported from our system contains leading zeros. It's Excel that hides them when you view the spreadsheet.
    Developer :: Bluepark Solutions

  4. #4
    Join Date
    Feb 2013
    Posts
    118

    Default

    Thanks RD,

    I think I will have to change my SKU format otherwise I will always have this problem when exporting and as my catalogue grows, so will the problem.

    Cheers,
    Paul

  5. #5
    Join Date
    Feb 2013
    Posts
    118

    Default

    Ah, OK thanks Rich.

    I don't see how you can show them by default when opening a csv file in Excel though. You have to rename the csv file .txt and then open it through the text file wizard. Here you can set the SKU column to 'text' rather than number.
    This is a faff to do every time I export (plus the increased potential to make mistakes) so it's probably better I change my SKU format now, since I'm in the early stages of setting up my site and it's not a problem.

    Thanks,
    Paul

  6. #6
    Join Date
    Jan 2012
    Posts
    764

    Default

    Even worse are bar codes! Wishes excel actually excelled.

  7. #7
    Join Date
    Dec 2011
    Location
    West Yorkshire
    Posts
    1,173

    Default

    Just put a letter at the beginning of your SKU's
    e.g T00123
    Terry

  8. #8
    Join Date
    Apr 2012
    Posts
    440

    Default

    To keep your leading zeros in Excel you need to import the CSV through DATA>FROM TEXT. Then select comma delimited and on the next screen select the SKU column and change the field data to text. This will maintain the zeros, but also maintains numbers if they are longer than 16 digits long.
    Shaun

    Loxta Hardware
    www.loxta.co.uk

  9. #9
    Join Date
    Feb 2013
    Posts
    118

    Default

    Quote Originally Posted by Terry View Post
    Just put a letter at the beginning of your SKU's
    e.g T00123
    This is what I've done in the end Terry.

  10. #10
    Join Date
    Dec 2011
    Location
    West Yorkshire
    Posts
    1,173

    Default

    Quote Originally Posted by Kitinglard View Post
    This is what I've done in the end Terry.
    Thats what I did, and works well - saves all the messing around with Excel etc

    Terry
    Terry

  11. #11
    Join Date
    Sep 2013
    Posts
    339

    Default

    Hi,
    I have increased all my prices by 5 percent by a export to excell. Will Bluepark round up the prices on import.
    Also we have long number sku's and numbers starting with zero's. If we follow this advice below after increasing the prices,

    "To keep your leading zeros in Excel you need to import the CSV through DATA>FROM TEXT. Then select comma delimited and on the next screen select the SKU column and change the field data to text. This will maintain the zeros, but also maintains numbers if they are longer than 16 digits long"

    Is there a way to save this excell file so we can import the file into Bluepark?

    Thanks

  12. #12
    Join Date
    Feb 2011
    Location
    West Midlands, England
    Posts
    993

    Default

    LibreOffice is free and last time I checked it keeps leading 0s and also doesn't do that stupid thing with barcodes that Excel does. I used to use it all the time when importing / exporting .csvs

  13. #13
    Join Date
    Feb 2011
    Location
    West Midlands, England
    Posts
    993

    Default

    You can have both Excel and LibreOffice installed and choose LibreOffice as the default program for .csvs , but keep Excel as the default program for spreadsheets, or Right Click > Open As to choose between the two.

  14. #14
    Join Date
    Sep 2013
    Posts
    339

    Default

    Thanks thats great

  15. #15
    Join Date
    Sep 2013
    Posts
    339

    Default

    Can you tell me the settings for LibraOffice please. The import preview looks ok but no prices are changed.

Similar Threads

  1. Keeping blocks visible in LH & RH columns for long pages
    By Bather in forum Bluepark Technical Discussion
    Replies: 0
    Last Post: 23-01-2013, 13:33
  2. Keeping news (not using blog) but blog mentioned in text
    By Deefer in forum Bluepark Technical Discussion
    Replies: 11
    Last Post: 02-11-2012, 16:27
  3. Keeping bluepark webspace down with Email forwarding?
    By Zen Overland in forum Bluepark Technical Discussion
    Replies: 17
    Last Post: 23-02-2011, 22:25

Posting Permissions

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

Bluepark's ecommerce software is developed, hosted and supported exclusively by ourselves, here in the UK, and has been so since the company was initially formed in 2004. Your brand new online shop will be hosted securely on our fast and reliable server network, using a domain name of your choice, providing the ability to build and maintain your ecommerce website, and manage your orders, from any location via your own secure online Administration Console.

A Bluepark ecommerce site is the perfect tool for selling online, whether you're selling physical products, digital downloads or services. You'll be in good company with over 1,000 UK customers who also form a friendly and helpful online community, further strengthening our highly acclaimed support network.

Find us on...