Page 1 of 2 12 LastLast
Results 1 to 10 of 18

Thread: Pastel - Inventory

  1. #1
    Junior Member
    Join Date
    Jul 2011
    Location
    Johannesburg
    Posts
    16
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Question Pastel - Inventory

    Hi again Everyone

    I am setting up a new store in Pastel - is there a way to import directly from Excel or will I need to retype my inventory?

    Elaine

  2. #2
    Gold Member Martinco's Avatar
    Join Date
    Oct 2008
    Location
    Rustenburg
    Posts
    927
    Thanks
    175
    Thanked 136 Times in 108 Posts
    It can be done but is quite complicated. If you do not have zillions of product codes I suggest you add these in the normal way.
    Martin Coetzee
    Supplier of Stainless Steel Band and Buckle and various fastening systems. Steel, Plastic, Galvanized, PET and Poly woven.
    We solve your fastening problems.
    www.straptite.com

    You may never know what results will come from your actions, but if you do nothing, there will be no results... Rudy Malan 05/03/2011

  3. #3
    Diamond Member Neville Bailey's Avatar
    Join Date
    Nov 2010
    Location
    Westville, Durban
    Posts
    2,760
    Thanks
    44
    Thanked 451 Times in 396 Posts
    Hi Elaine,

    It is possible to import your inventory masterfile data from a Excel CSV file, but it needs to be set up in a very specific layout.

    Give me a shout if you need any assistance - I can log onto your system remotely.
    Neville Bailey - Sage Pastel Accounting Consultant
    www.accountingsoftwaresupport.co.za
    neville@accountingsoftwaresupport.co.za
    IronTree Online Solutions

    "Give every person more in use value than you take from them in cash value."
    WALLACE WATTLES (1860-1911)

  4. #4
    Junior Member
    Join Date
    Jul 2011
    Location
    Johannesburg
    Posts
    16
    Thanks
    1
    Thanked 0 Times in 0 Posts
    I have about 1000 items - what layout should it be in?

  5. #5
    Diamond Member Neville Bailey's Avatar
    Join Date
    Nov 2010
    Location
    Westville, Durban
    Posts
    2,760
    Thanks
    44
    Thanked 451 Times in 396 Posts
    Go to Pastel Help and search under Index for Export / Import - you will find the layout requirements there.

    Another way of finding out what the layout is, is to create one stock item manually and the export the inventory masterfile onto a CSV file - then you can simply copy and paste your other stock items from your Excel file.

    Beware - if you have never done this before, you are bound to get frustrated as the formats of the various columns have to be precisely correct!
    Neville Bailey - Sage Pastel Accounting Consultant
    www.accountingsoftwaresupport.co.za
    neville@accountingsoftwaresupport.co.za
    IronTree Online Solutions

    "Give every person more in use value than you take from them in cash value."
    WALLACE WATTLES (1860-1911)

  6. Thanks given for this post:

    Dave A (29-Jul-11)

  7. #6
    Gold Member Martinco's Avatar
    Join Date
    Oct 2008
    Location
    Rustenburg
    Posts
    927
    Thanks
    175
    Thanked 136 Times in 108 Posts
    Quote Originally Posted by Neville Bailey View Post
    Beware - if you have never done this before, you are bound to get frustrated as the formats of the various columns have to be precisely correct!
    That is what caused me to give up eventually but for a 1000 items it would be worth while to battle a bit.
    As Neville said...........it is the formats that gets very tricky.
    My suggestion would be that you do the export and just add one item and play around till you get the file to import correctly, then add the other items.
    Martin Coetzee
    Supplier of Stainless Steel Band and Buckle and various fastening systems. Steel, Plastic, Galvanized, PET and Poly woven.
    We solve your fastening problems.
    www.straptite.com

    You may never know what results will come from your actions, but if you do nothing, there will be no results... Rudy Malan 05/03/2011

  8. #7
    Junior Member
    Join Date
    Jul 2011
    Location
    Johannesburg
    Posts
    16
    Thanks
    1
    Thanked 0 Times in 0 Posts
    Hi all

    Once again - I am back...
    As a new Pastel user I have found this very frustrating....

    Can one of you experts out ther help me If I give you an example of what I want in my inventory file?

    Elaine

  9. #8
    Silver Member geraldenek's Avatar
    Join Date
    Jul 2008
    Location
    Somerset West
    Posts
    229
    Thanks
    19
    Thanked 112 Times in 80 Posts
    Hi Elaine

    On your pastel - go to edit, inventory, item file just create one item by putting in all the information on all the tabs as you would like it done. save this

    Then go to File, export/import, export inventory items

    click on the export inventory file and expand it, choose where you would like to have it saved and the name. before you hit save put .csv after the file name

    click save,process

    this will have the file in an excel format and you can copy and paste what you need from your orignal excel file to the new one. and you can just import it again the same way just remember to untick the box which states map fields
    Geraldene Kapp
    Professional Tax Help
    www.mytaxhelp.co.za

  10. #9
    New Member
    Join Date
    Sep 2012
    Location
    Gauteng
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Hallo people

    Why is it so difficult for Pastel or softline to load an excel template with all the column fields with the correct headers.

    common make it simple stupid for goodness sake.

  11. #10
    Gold Member Martinco's Avatar
    Join Date
    Oct 2008
    Location
    Rustenburg
    Posts
    927
    Thanks
    175
    Thanked 136 Times in 108 Posts
    Quote Originally Posted by geraldenek View Post
    Hi Elaine

    On your pastel - go to edit, inventory, item file just create one item by putting in all the information on all the tabs as you would like it done. save this
    Just another tip on inventory:
    When creating your inventory codes and descriptions.....................steer clear of using special characters (,./>< etc. etc. ) as this confuses the .csv file and causes the columns to shift.
    When importing this will cause errors.
    Martin Coetzee
    Supplier of Stainless Steel Band and Buckle and various fastening systems. Steel, Plastic, Galvanized, PET and Poly woven.
    We solve your fastening problems.
    www.straptite.com

    You may never know what results will come from your actions, but if you do nothing, there will be no results... Rudy Malan 05/03/2011

Page 1 of 2 12 LastLast

Similar Threads

  1. Replies: 3
    Last Post: 19-Jul-18, 11:49 AM
  2. Replies: 3
    Last Post: 24-Jun-11, 04:59 PM
  3. Replies: 7
    Last Post: 21-Feb-11, 09:45 AM
  4. [Question] Pastel
    By Martinco in forum General Business Forum
    Replies: 5
    Last Post: 19-Jan-11, 08:38 AM
  5. Proper Inventory Control
    By sgafc in forum Entrepreneurship and Business Management Forum
    Replies: 0
    Last Post: 25-Mar-09, 12:38 PM

Did you like this article? Share it with your favourite social network.

Did you like this article? Share it with your favourite social network.

Posting Permissions

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