Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Sign in to follow this  
JonCloud

Easypopulate & Bulk Pricing

Recommended Posts

Hello all,

 

I think I posted something about this awhile ago and I got most of the answer I need. Today, I seek the rest.

 

I use easypopulate with great success, but I have one problem, and it is really an excel question, but I am hoping someone here can help because you should be able to understand my issue.

 

I have a big csv file from my supplier and it contains all of my relevant product info and pricing. As far as pricing, it has a "wholesale column", and a "list price column". I went ahead and made "my own pricing column" in which I applied a formula to the "wholesale column" and retrieved my pricing. Get it? Here comes my problem.

 

I then selected the data from "my own pricing column" and copied it. I then pasted it into my easypopulate file, but instead of pasting the actual prices, it pasted the formula, which is dependent on data in the next column. Still with me?

 

Ok, this doesnt work for obvious reasons. Does anyone know how I can achieve my goal of bulk pricing my products?

 

Any help will be much appreciated.

 

Thanks,

JonCloud

Share this post


Link to post
Share on other sites
select the column with the forumula and 'copy', then select where you are going to paste, then choose paste special and select 'value'

 

 

That worked great!! Thanks!! :thumbsup:

Share this post


Link to post
Share on other sites
Hello all,

 

I think I posted something about this awhile ago and I got most of the answer I need. Today, I seek the rest.

 

I use easypopulate with great success, but I have one problem, and it is really an excel question, but I am hoping someone here can help because you should be able to understand my issue.

 

I have a big csv file from my supplier and it contains all of my relevant product info and pricing. As far as pricing, it has a "wholesale column", and a "list price column". I went ahead and made "my own pricing column" in which I applied a formula to the "wholesale column" and retrieved my pricing. Get it? Here comes my problem.

 

I then selected the data from "my own pricing column" and copied it. I then pasted it into my easypopulate file, but instead of pasting the actual prices, it pasted the formula, which is dependent on data in the next column. Still with me?

 

Ok, this doesnt work for obvious reasons. Does anyone know how I can achieve my goal of bulk pricing my products?

 

Any help will be much appreciated.

 

Thanks,

JonCloud

 

Hi Jon:

 

I am planning on (and trying to figure out) how to add the two prices you mentioned to my site as I want to sell both wholesale and retail. My problem is that I don't know where to find a contribution to display both prices. I can only find the one for displaying with/without VAT.

 

Can you let me know how you did it?

 

Thanks alot

 

Kelvin

Share this post


Link to post
Share on other sites
Hi Jon:

 

I am planning on (and trying to figure out) how to add the two prices you mentioned to my site as I want to sell both wholesale and retail. My problem is that I don't know where to find a contribution to display both prices. I can only find the one for displaying with/without VAT.

 

Can you let me know how you did it?

 

Thanks alot

 

Kelvin

 

Search the contributions section. I am sure there is somthing for this, or at least somthing close. I am using OscMAX, which has a field for entering the wholesale price when you add a product. So it at least gets it in the database. Also, it has a contribution in it, I think it is "seperate price per customer", which allows you to have both wholesale and retail customers.

 

Hope that helps.

 

JonCloud

Share this post


Link to post
Share on other sites

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×