myhero Posted February 24, 2011 Share Posted February 24, 2011 Hi,I am going to upload many pricelists to my website and need to know what is the most efficient way to do this?Are there any modules/application out there that can assist with this as it cannot be done manually. And will have to be done weekly from different suppliers pricelists.Does any1 have a solution for this?Tx Link to comment Share on other sites More sharing options...
Kelvin Koh Posted February 24, 2011 Share Posted February 24, 2011 Do your suppliers give you the price lists in Excel / OpenOffice Calc or CSV file formats? If that is so, you can use BO's import feature to do that. Link to comment Share on other sites More sharing options...
myhero Posted February 24, 2011 Author Share Posted February 24, 2011 They give it to me in Excel format. I have created an excel sheet and basically copy and paste into another using Excel contacetante function. Which can take time.I have attached screenshots. I spend a lot of time creating / updating my list and have many to do each week. There has to be a simplier way, I might not be doing it right.... Please see attached. Link to comment Share on other sites More sharing options...
myhero Posted February 24, 2011 Author Share Posted February 24, 2011 Is there an easier way, maybe having a sheet that will pull the info from the supplier's PL? Link to comment Share on other sites More sharing options...
myhero Posted February 24, 2011 Author Share Posted February 24, 2011 Had the supplier create their pricelists in CSV format instead, solved my issue Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now