Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Easy Populate 2.78 With Sppc + Price Breaks Upload Problem


adz1976

Recommended Posts

Hi

 

MS2

SQLv5.0

SPPC v4.1 + Price Breaks v1.0 for SPPC v4.1

EP2.78 + SPPC + Price Breaks

 

I have Easy Populate 2.78 With Sppc + Price Breaks, I can download & upload the SPPC with price breaks fine but

just wondering how I can just upload a certain customers prices rather than the whole lot.

 

i.e.

 

At the minute I have 5 customers.

Instead of uploading all 5 customer prices, I would like to upload customer 3's prices only.

 

As you can see below the reason why I just want to work with 1 customers prices at a time it gets very complicated,

as each group contains the following fields.

 

In excel after the download, I deleted the following fields for customers _1,_2,_4 & _5 as shown below:

 

*v_products_model* - Model is just at the start of fields for reference with EP

 

v_customer_price_1

v_customer_group_id_1

v_products_price1_1

v_products_price2_1

v_products_price3_1

v_products_price4_1

v_products_price5_1

v_products_price6_1

v_products_price7_1

v_products_price8_1

v_products_price1_qty_1

v_products_price2_qty_1

v_products_price3_qty_1

v_products_price4_qty_1

v_products_price5_qty_1

v_products_price6_qty_1

v_products_price7_qty_1

v_products_price8_qty_1

v_products_qty_blocks_1

 

v_customer_price_2

v_customer_group_id_2

v_products_price1_2

and so on.......

 

I have tried to upload a file with v_products_model + customer 3 fields

but no prices change even though it says uploaded.

 

It's as if you have to have every field which is included in the products_groups_table for the prices to change.

 

Is there anyway around this problem ?

 

Prices only change when you have all fields from Cutomer 1 to Customer 5 in the excel file.

 

I have tried a few changes in the easypopulate.php but with no avail.

i.e. disabling cutomers 1,2,4,5 under the special prices per customers section

 

Anyone have any good ideas, I really hope you do :-)

 

Many thanks

 

Adam :-)

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...