Jump to content

way2real

New Members
  • Posts

    5
  • Joined

  • Last visited

    Never

Posts posted by way2real

  1. Thank you Sasa.  I appreciate the quick response. 

     

    Maybe I should have included more information.  I am having a tough time wrapping my head around this and how to get it to work for what I have in mind.

     

    Using the csv file from the earlier post, the below is what I would like to accomplish:

     

    <?php
    $sku = 'ML2225-1/4';
    $tierPrices = array();
    
    //first tier price
    $tierPrices[] = array(
        'qty' => 10,
        'price' => 38.77
    ); 
    
    //second tier price
    $tierPrices[] = array(
        'qty' => 20,
        'price' => 36.00
    ); 
    
    //third tier price
    $tierPrices[] = array(
        'qty' => 30,
        'price' => 33.23
    ); 
    
    // save the tier prices
    $proxy->call('tierprice.update', array('ML2225-1/4', $tierPrices)); 
    
    //LOOP THROUGH THE LIST TO PROCESS EACH UNIQUE SKU
    //ML2225-5/16 WOULD BE NEXT, THEN
    //ML2225-3/8, ETC.
    
    ?>
    

     

    I appreciate any thoughts.

  2. I have following in a csv file:

     

    sku,quantity,price

    ----------------------

    ML2225-1/4,10,38.77

    ML2225-1/4,20,36

    ML2225-1/4,30,33.23

    ML2225-5/16,10,35.94

    ML2225-5/16,20,33.37

    ML2225-5/16,30,30.8

    ML2225-3/8,10,34.37

    ML2225-3/8,20,31.92

    ML2225-3/8,30,29.46

    ML2225-7/16,10,34.37

    ML2225-7/16,20,31.92

    ML2225-7/16,30,29.46

    ML2225-1/2,10,34.37

    ML2225-1/2,20,31.92

    ML2225-1/2,30,29.46

    ...

     

    I am able to read the file (fgetcsv).  How do I build an array for each unique sku set, then do something, then continue to the next unique sku set?

     

    Thanks,

    Mike

     

  3. MySQL version: 4.1.22

     

    SELECT groups.description AS groupdescription, directory, image_id
    FROM (events INNER JOIN images ON events.event_id = images.event_id)
    INNER JOIN groups ON events.group_id = groups.group_id
    WHERE events.group_id = "Group1"

     

    MySQL said: Documentation

    #1017 - Can't find file: 'events' (errno: 2)

     

    Can someone help me correct the problem?

    Thank you.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.