Welcome to The Forum SA. As a visitor you have read only access to the public content areas of this website. You will have to register as a member to access all content, post messages and network with our members. Membership is free and registering is quick and easy. You can click here to register now and become a member within minutes.
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
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!
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
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
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
thank you for the great assistance in almost importing my inventory. i am using xpress 12 and keep getting the same 'group does not exist'' error. even when i export a csv and make an exact copy of the first line(with different inventory code). when importing i will get an error saying that the second line has an error, but the first has been succesfully imported....but they are the exact copy...i'm confused.
please assist
I am also using xpress 12 . when importing i will get an error saying 'group does not exist'' . when i change it to text and 002, it works. It then goes through all the steps as it is importing and then when finished it says that there is no inventory imported. Please Help. I have 2500 items to import. setting up a new set of books.
I'm sitting working, struggling with a few Pastel import/export issues but, thanks to you once again, I am gradually getting them sorted. Just thought I should let you know! It's many a night your threads have helped me. Thank you!!
I have done many successful inventory imports in the past with Pastel/Excl, though now for some reason I am battling. I get an error that would say that the inventory group does not exist for certain lines, however the group does exist. For example it will say the error is in lines 1-6 and then 11,12,13 etc
If I export the existing inventory and then re-import (with the same inventoy group) it imports perfectly!
I have done many successful inventory imports in the past with Pastel/Excl, though now for some reason I am battling. I get an error that would say that the inventory group does not exist for certain lines, however the group does exist. For example it will say the error is in lines 1-6 and then 11,12,13 etc
If I export the existing inventory and then re-import (with the same inventoy group) it imports perfectly!
Any ideas?
Make sure there are no double-quotation characters in the inventory descriptions, as they mess around with the column separation.
We process personal data about users of our site, through the use of cookies and other technologies, to deliver our services, personalize advertising, and to analyze site activity. We may share certain information about our users with our advertising and analytics partners. For additional details, refer to our Privacy Policy.
By clicking "I AGREE" below, you agree to our Privacy Policy and our personal data processing and cookie practices as described therein. You also acknowledge that this forum may be hosted outside your country and you consent to the collection, storage, and processing of your data in the country where this forum is hosted.
Tweet
Comment