function submit_products()
{
$start = 0;
while (true) {
$inventories = Inventory::whereNull('shopify_id')->orWhere('dirty', 1)->skip($start)->take(100)->get();
$cnt = count($inventories);
if ($cnt == 0) {
break;
}
foreach ($inventories as $inventory) {
if ($inventory->image == '') {
continue;
}
if ($inventory->shopify_id == NULL) {
$amzInfo = AmazonInfo::where("inventory_id", $inventory->id)->first();
$collection = Collection::where("name", $amzInfo->category1)->first();
if ($collection == NULL) {
//echo '[', date('Y-m-d H:m:s'), '] Skip - ', $inventory->name, "\r\n";
continue;
}
$result = create_product($inventory->name, $inventory->description, 'Bellwether', 'Book', $inventory->sku, $inventory->price, $inventory->quantity, $inventory->image, $inventory->isbn);
if ($result['success'] == 'true') {
/*
Check if collection exists and add product & category...
*/
if ($collection != NULL) {
$inventory->dirty = 0;
$sid = $result['product']['id'];
$inventory->shopify_id = $sid;
$inventory->save();
echo '[', date('Y-m-d H:m:s'), '] Added Product - ', "ID ", $sid, ", ", $inventory->name, "\r\n";
add_product_to_collection($result['product']['id'], $collection->shopify_id);
echo 'Added to Collection - ' . $collection->name . "\r\n";
}
}
} else {
$result = update_product_content($inventory->shopify_id, $inventory->price, $inventory->quantity, $inventory->sku);
if ($result['success'] == 'true') {
$inventory->dirty = 0;
$inventory->save();
echo 'Updated Product - ' . $inventory->name . "\r\n";
}
}
}
$start += $cnt;
}
}
function submit_products()
{
$start = 0;
while (true) {
$inventories = Inventory::where('dirty', 1)->take(100)->get();
$cnt = count($inventories);
if ($cnt == 0) {
break;
}
foreach ($inventories as $inventory) {
if ($inventory->image == '') {
$inventory->dirty = -3;
$inventory->save();
continue;
}
$inventory = Inventory::where('isbn', $inventory->isbn)->orderBy('price', 'asc')->first();
Inventory::where('isbn', $inventory->isbn)->update(['dirty' => 0]);
if ($inventory->shopify_id == NULL) {
$amzInfo = AmazonInfo::where("inventory_id", $inventory->id)->first();
$collection = Collection::where("name", $amzInfo->category1)->first();
if ($amzInfo->url == null || $amzInfo->description == null) {
continue;
}
$dimension = $amzInfo->width . 'W x ' . $amzInfo->height . 'H x ' . $amzInfo->length . 'L (in)';
$result = create_product($inventory->name, $amzInfo->description, 'Bellwether', 'Book', $inventory->sku, $inventory->price, $inventory->quantity, $inventory->image, $inventory->isbn, $amzInfo->list_price, $inventory->condition, $inventory->author, $inventory->publisher, $dimension, $amzInfo->pages, $amzInfo->url);
print_r($result);
if ($result['success'] == 'true') {
$inventory->dirty = 0;
$sid = $result['product']['id'];
$inventory->shopify_id = $sid;
$inventory->shopify_var_id = $result['variants'][0]['id'];
$inventory->save();
echo 'Added Product - ', "ID ", $sid, ", ", $inventory->name, "\r\n";
/*
Add collection...
*/
if ($collection != NULL) {
add_product_to_collection($result['product']['id'], $collection->shopify_id);
echo 'Added to Collection - ' . $collection->name . "\r\n";
}
} else {
echo 'Failed Product - ', "ID ", $sid, ", ", $inventory->name, "\r\n";
$inventory->dirty = -1;
$inventory->save();
}
} else {
if ($amzInfo->url == null || $amzInfo->description == null) {
continue;
}
$result = update_product_content($inventory->shopify_id, $inventory->name, $amzInfo->description, $inventory->sku, $inventory->price, $inventory->quantity, $inventory->isbn, $amzInfo->list_price, $inventory->condition, $inventory->author, $inventory->publisher, $dimension, $amzInfo->pages, $amzInfo->url);
if ($result['success'] == 'true') {
$inventory->dirty = 0;
$inventory->save();
echo 'Updated Product - ' . $inventory->name . "\r\n";
} else {
echo 'Failed to update Product - ' . $inventory->name . "\r\n";
echo json_encode($result), "r\n";
$inventory->dirty = -2;
$inventory->save();
}
}
//usleep(100);
}
$start += $cnt;
}
}
