Jump to content

Loop through an array


way2real

Recommended Posts

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

 

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

try

<?php
$handle = fopen('test.csv', 'r');
while ($line = fgetcsv($handle)) $out[$line[0]][] = array('qty' =>$line[1], 'price' => $line[2]);
foreach ($out as $aku => $tierPrices) $proxy->call('tierprice.update', array($aku, $tierPrices));
?>

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • 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.