/** * Get the add to cart URL for a product * * @param array $atts * @return string */ public static function product_add_to_cart_url($atts) { global $wpdb; if (empty($atts)) { return ''; } if (isset($atts['id'])) { $product_data = get_post($atts['id']); } elseif (isset($atts['sku'])) { $product_id = wc_get_product_id_by_sku($atts['sku']); $product_data = get_post($product_id); } else { return ''; } if ('product' !== $product_data->post_type) { return ''; } $_product = wc_get_product($product_data); return esc_url($_product->add_to_cart_url()); }
/** * Create or update a line item * * @since 2.2 * @param \WC_Order $order * @param array $item line item data * @param string $action 'create' to add line item or 'update' to update it * @throws WC_API_Exception invalid data, server error */ protected function set_line_item($order, $item, $action) { $creating = 'create' === $action; // product is always required if (!isset($item['product_id']) && !isset($item['sku'])) { throw new WC_API_Exception('woocommerce_api_invalid_product_id', __('Product ID or SKU is required', 'woocommerce'), 400); } // when updating, ensure product ID provided matches if ('update' === $action) { $item_product_id = wc_get_order_item_meta($item['id'], '_product_id'); $item_variation_id = wc_get_order_item_meta($item['id'], '_variation_id'); if ($item['product_id'] != $item_product_id && $item['product_id'] != $item_variation_id) { throw new WC_API_Exception('woocommerce_api_invalid_product_id', __('Product ID provided does not match this line item', 'woocommerce'), 400); } } if (isset($item['product_id'])) { $product_id = $item['product_id']; } elseif (isset($item['sku'])) { $product_id = wc_get_product_id_by_sku($item['sku']); } // variations must each have a key & value $variation_id = 0; if (isset($item['variations']) && is_array($item['variations'])) { foreach ($item['variations'] as $key => $value) { if (!$key || !$value) { throw new WC_API_Exception('woocommerce_api_invalid_product_variation', __('The product variation is invalid', 'woocommerce'), 400); } } $variation_id = $this->get_variation_id(wc_get_product($product_id), $item['variations']); } $product = wc_get_product($variation_id ? $variation_id : $product_id); // must be a valid WC_Product if (!is_object($product)) { throw new WC_API_Exception('woocommerce_api_invalid_product', __('Product is invalid', 'woocommerce'), 400); } // quantity must be positive float if (isset($item['quantity']) && floatval($item['quantity']) <= 0) { throw new WC_API_Exception('woocommerce_api_invalid_product_quantity', __('Product quantity must be a positive float', 'woocommerce'), 400); } // quantity is required when creating if ($creating && !isset($item['quantity'])) { throw new WC_API_Exception('woocommerce_api_invalid_product_quantity', __('Product quantity is required', 'woocommerce'), 400); } if ($creating) { $item = new WC_Order_Item_Product(); } else { $item = new WC_Order_Item_Product($item['id']); } $item->set_product($product); $item->set_order_id($order->id); if (isset($item['quantity'])) { $item->set_quantity($item['quantity']); } if (isset($item['total'])) { $item->set_total(floatval($item['total'])); } if (isset($item['total_tax'])) { $item->set_total_tax(floatval($item['total_tax'])); } if (isset($item['subtotal'])) { $item->set_subtotal(floatval($item['subtotal'])); } if (isset($item['subtotal_tax'])) { $item->set_subtotal_tax(floatval($item['subtotal_tax'])); } if ($variation_id) { $item->set_variation_id($variation_id); $item->set_variation($item['variations']); } $item_id = $item->save(); if (!$item_id) { throw new WC_API_Exception('woocommerce_cannot_create_line_item', __('Cannot create line item, try again', 'woocommerce'), 500); } }
/** * Get the add to cart URL for a product. * * @param array $atts * @return string */ public static function product_add_to_cart_url($atts) { global $wpdb; if (empty($atts)) { return ''; } if (isset($atts['id'])) { $product_data = get_post($atts['id']); } elseif (isset($atts['sku'])) { $product_id = wc_get_product_id_by_sku($atts['sku']); $product_data = get_post($product_id); } else { return ''; } $product = is_object($product_data) && in_array($product_data->post_type, array('product', 'product_variation')) ? wc_setup_product_data($product_data) : false; if (!$product) { return ''; } $_product = wc_get_product($product_data); return esc_url($_product->add_to_cart_url()); }
/** * Gets the product ID from the SKU or posted ID. * @param array $posted Request data * @return int */ protected function get_product_id($posted) { if (!empty($posted['sku'])) { $product_id = (int) wc_get_product_id_by_sku($posted['sku']); } elseif (!empty($posted['product_id']) && empty($posted['variation_id'])) { $product_id = (int) $posted['product_id']; } elseif (!empty($posted['variation_id'])) { $product_id = (int) $posted['variation_id']; } else { throw new WC_REST_Exception('woocommerce_rest_required_product_reference', __('Product ID or SKU is required.', 'woocommerce'), 400); } return $product_id; }
function wc_autoship_import_muenster_file() { set_time_limit(300); header('Content-Type: application/json'); // Check if file is valid if (empty($_FILES['uploadedFiles']['error']) || $_FILES['uploadedFiles']['error'][0] !== UPLOAD_ERR_OK) { echo json_encode(array('error' => 'Upload error code: ' . $_FILES['uploadedFiles']['error'][0])); die; } // Open file $file = fopen($_FILES['uploadedFiles']['tmp_name'][0], 'r'); if (!$file) { echo json_encode(array('error' => 'Could not open file')); die; } // Read column headers $column_headers = fgetcsv($file); if (empty($column_headers)) { echo json_encode(array('error' => 'Invalid file format')); die; } $columns = array(); foreach ($column_headers as $index => $name) { $columns[$name] = $index; } $column_names = array('Customer Email', 'Next Shipping Date', 'Shipping Method', 'Frequency', 'Quantity', 'Product SKU'); foreach ($column_names as $name) { if (!isset($columns[$name])) { echo json_encode(array('error' => 'Missing column: ' . $name)); die; } } // Include dependencies require_once WP_PLUGIN_DIR . '/woocommerce-autoship/classes/wc-autoship-customer.php'; require_once WP_PLUGIN_DIR . '/woocommerce-autoship/classes/wc-autoship-schedule.php'; require_once WP_PLUGIN_DIR . '/woocommerce-autoship/classes/wc-autoship-schedule-item.php'; // Process file $result = array(); while ($row = fgetcsv($file)) { // Get email $email = $row[$columns['Customer Email']]; if (empty($email)) { // Email is empty, skip this record continue; } $result_item = array('data' => array_combine($column_headers, $row)); // Find existing user $user_id = 0; $user = get_user_by('email', $email); if (!$user) { $result_item['error'] = "User not found for email {$email}"; $result[] = $result_item; continue; } else { $user_id = $user->ID; } $result_item['data']['user_id'] = $user_id; if (empty($user_id) || is_object($user_id)) { $result_item['error'] = 'Invalid user_id'; $result[] = $result_item; continue; } // Create autoship customer $customer = new WC_Autoship_Customer($user_id); $customer->set('shipping_method', $row[$columns['Shipping Method']]); if (false === $customer->save()) { // Error creating autoship customer $result_item['error'] = 'Error creating autoship customer'; $result[] = $result_item; continue; } // Create autoship schedule item $product_id = wc_get_product_id_by_sku($row[$columns['Product SKU']]); if (empty($product_id)) { // Product does not exist $result_item['error'] = 'Product SKU not found'; $result[] = $result_item; continue; } $result_item['data']['product_id'] = $product_id; $product = wc_get_product($product_id); $item = new WC_Autoship_Schedule_Item(); if ($product->is_type('simple')) { $item->set('product_id', $product_id); } elseif ($product->is_type('variation')) { $item->set('variation_id', $product_id); $item->set('product_id', $product->get_parent()); } $item->set('qty', $row[$columns['Quantity']]); // Create autoship schedule $frequency_desc = $row[$columns['Frequency']]; $frequency_matches = null; if (!preg_match('/(\\d+) Month/', $frequency_desc, $frequency_matches)) { // Error saving autoship schedule $result_item['error'] = "Invalid Frequency: {$frequency_desc}"; $result[] = $result_item; continue; } $frequency = 30 * (int) $frequency_matches[1]; $schedule = WC_Autoship_Schedule::get_schedule($user_id, $frequency); $schedule->set_autoship_status(WC_Autoship::STATUS_PAUSED); $schedule->set_next_order_date(date('Y-m-d', strtotime($row[$columns['Next Shipping Date']]))); $schedule->add_item($item); if (false === $schedule->save()) { // Error saving autoship schedule $result_item['error'] = 'Error saving autoship schedule'; $result[] = $result_item; continue; } $result[] = $result_item; } fclose($file); echo json_encode($result); die; }
function wc_autoship_import_paymentxp_file() { set_time_limit(300); header('Content-Type: application/json'); // Check if file is valid if (empty($_FILES['uploadedFiles']['error']) || $_FILES['uploadedFiles']['error'][0] !== UPLOAD_ERR_OK) { echo json_encode(array('error' => 'Upload error code: ' . $_FILES['uploadedFiles']['error'][0])); die; } // Open file $file = fopen($_FILES['uploadedFiles']['tmp_name'][0], 'r'); if (!$file) { echo json_encode(array('error' => 'Could not open file')); die; } // Read column headers $column_headers = fgetcsv($file); if (empty($column_headers)) { echo json_encode(array('error' => 'Invalid file format')); die; } $columns = array(); foreach ($column_headers as $index => $name) { $columns[$name] = $index; } $column_names = array('email', 'autoship frequency', 'next order date', 'product sku', 'item quantity', 'username', 'password', 'pxp_customer_id', 'pmt_desc', 'display_name', 'user_nicename', 'first_name', 'last_name', 'phone', 'billing_phone', 'billing_address', 'billing_address_1', 'billing_address_2', 'billing_city', 'billing_state', 'billing_zip', 'billing_postcode', 'billing_country', 'billing_last_name', 'billing_first_name', 'shipping_address_1', 'shipping_address_2', 'shipping_city', 'shipping_state', 'shipping_postcode', 'shipping_country', 'shipping_last_name', 'shipping_first_name', 'shipping_method', 'role', 'affwp_lc_email', 'affwp_lc_affiliate_id'); $usermeta_column_names = array('phone', 'billing_phone', 'billing_address', 'billing_address_1', 'billing_address_2', 'billing_city', 'billing_state', 'billing_zip', 'billing_postcode', 'billing_country', 'billing_last_name', 'billing_first_name', 'shipping_address_1', 'shipping_address_2', 'shipping_city', 'shipping_state', 'shipping_postcode', 'shipping_country', 'shipping_last_name', 'shipping_first_name', 'affwp_lc_email', 'affwp_lc_affiliate_id'); foreach ($column_names as $name) { if (!isset($columns[$name])) { echo json_encode(array('error' => 'Missing column: ' . $name)); die; } } // Include dependencies require_once WP_PLUGIN_DIR . '/woocommerce-autoship/classes/wc-autoship-customer.php'; require_once WP_PLUGIN_DIR . '/woocommerce-autoship/classes/wc-autoship-schedule.php'; require_once WP_PLUGIN_DIR . '/woocommerce-autoship/classes/wc-autoship-schedule-item.php'; // Process file $result = array(); while ($row = fgetcsv($file)) { // Get email $email = $row[$columns['email']]; if (empty($email)) { // Email is empty, skip this record continue; } $result_item = array('data' => array_combine($column_headers, $row)); // Find existing user $user_id = 0; $user = get_user_by('email', $email); if (!$user) { // Create new user $user_id = @wp_create_user($row[$columns['username']], $row[$columns['password']], $email); if (!$user_id) { $result_item['error'] = 'Error creating user'; $result[] = $result_item; continue; } @wp_update_user(array('ID' => $user_id, 'user_nicename' => $row[$columns['user_nicename']], 'display_name' => $row[$columns['display_name']], 'first_name' => $row[$columns['first_name']], 'last_name' => $row[$columns['last_name']], 'role' => $row[$columns['role']])); // Add user meta foreach ($usermeta_column_names as $name) { add_user_meta($user_id, $name, $row[$columns[$name]], true); } } else { $user_id = $user->ID; } $result_item['data']['user_id'] = $user_id; if (empty($user_id) || is_object($user_id)) { $result_item['error'] = 'Invalid user_id'; $result[] = $result_item; continue; } // Create autoship customer $customer = new WC_Autoship_Customer($user_id); $customer->store_payment_method('wc_autoship_paymentxp', $row[$columns['pxp_customer_id']], array('CustomerID' => $row[$columns['pxp_customer_id']], 'CardNumber' => $row[$columns['pmt_desc']])); $customer->set('shipping_method', $row[$columns['shipping_method']]); if (false === $customer->save()) { // Error creating autoship customer $result_item['error'] = 'Error creating autoship customer'; $result[] = $result_item; continue; } // Create autoship schedule item $product_id = wc_get_product_id_by_sku($row[$columns['product sku']]); if (empty($product_id)) { // Product does not exist $result_item['error'] = 'Product SKU not found'; $result[] = $result_item; continue; } $result_item['data']['product_id'] = $product_id; $product = wc_get_product($product_id); $item = new WC_Autoship_Schedule_Item(); if ($product->is_type('simple')) { $item->set('product_id', $product_id); } elseif ($product->is_type('variation')) { $item->set('variation_id', $product_id); $item->set('product_id', $product->get_parent()); } $item->set('qty', $row[$columns['item quantity']]); // Create autoship schedule $schedule = WC_Autoship_Schedule::get_schedule($user_id, $row[$columns['autoship frequency']]); $schedule->set_autoship_status(WC_Autoship::STATUS_ACTIVE); $schedule->set_next_order_date(date('Y-m-d', strtotime($row[$columns['next order date']]))); $schedule->add_item($item); if (false === $schedule->save()) { // Error saving autoship schedule $result_item['error'] = 'Error saving autoship schedule'; $result[] = $result_item; continue; } $result[] = $result_item; } fclose($file); echo json_encode($result); die; }
/** * Get product by SKU * * @since 2.3.0 * @param int $sku the product SKU * @param string $fields * @return array */ public function get_product_by_sku($sku, $fields = null) { try { $id = wc_get_product_id_by_sku($sku); if (empty($id)) { throw new WC_API_Exception('woocommerce_api_invalid_product_sku', __('Invalid product SKU', 'woocommerce'), 404); } return $this->get_product($id, $fields); } catch (WC_API_Exception $e) { return new WP_Error($e->getErrorCode(), $e->getMessage(), array('status' => $e->getCode())); } }
public function sync() { global $wp; global $wpdb; set_time_limit(0); @ini_set('display_errors', '1'); @ini_set('zlib.output_compression', 'Off'); @ini_set('output_buffering', 'Off'); @ini_set('output_handler', ''); while (ob_get_level() > 1) { @ob_end_clean(); } if (ob_get_level() > 0) { @ob_clean(); } if (!in_array('woocommerce/woocommerce.php', apply_filters('active_plugins', get_option('active_plugins')))) { $this->sendHttpHeaders('500 Config Error', array('Content-Type' => 'application/json', 'Cache-Control' => 'no-cache, no-store', 'Expires' => 'Thu, 01 Jan 1970 00:00:00 GMT', 'Pragma' => 'no-cache')); echo $this->json_encode(array('ack' => 'failed', 'message' => 'WooCommerce Deactivated')); exit; } $type = $wp->query_vars['codisto-sync-route']; if (strtolower($_SERVER['REQUEST_METHOD']) == 'get') { if ($type == 'test' || $type == 'sync' && preg_match('/\\/sync\\/testHash\\?/', $_SERVER['REQUEST_URI'])) { if (!$this->check_hash()) { exit; } $this->sendHttpHeaders('200 OK', array('Content-Type' => 'application/json', 'Cache-Control' => 'no-cache, no-store', 'Expires' => 'Thu, 01 Jan 1970 00:00:00 GMT', 'Pragma' => 'no-cache')); echo $this->json_encode(array('ack' => 'ok')); } else { if ($type === 'settings') { if (!$this->check_hash()) { exit; } $logo_url = get_header_image(); if (function_exists('site_logo')) { $logo = site_logo()->logo; $logo_id = get_theme_mod('custom_logo'); $logo_id = $logo_id ? $logo_id : $logo['id']; if ($logo_id) { $logo_url = wp_get_attachment_image_src($logo_id, 'full'); $logo_url = $logo_url[0]; } } $currency = get_option('woocommerce_currency'); $dimension_unit = get_option('woocommerce_dimension_unit'); $weight_unit = get_option('woocommerce_weight_unit'); $default_location = explode(':', get_option('woocommerce_default_country')); $country_code = isset($default_location[0]) ? $default_location[0] : ''; $state_code = isset($default_location[1]) ? $default_location[1] : ''; $response = array('ack' => 'ok', 'logo' => $logo_url, 'currency' => $currency, 'dimension_unit' => $dimension_unit, 'weight_unit' => $weight_unit, 'country_code' => $country_code, 'state_code' => $state_code); $this->sendHttpHeaders('200 OK', array('Content-Type' => 'application/json', 'Cache-Control' => 'no-cache, no-store', 'Expires' => 'Thu, 01 Jan 1970 00:00:00 GMT', 'Pragma' => 'no-cache')); echo $this->json_encode($response); exit; } else { if ($type === 'tax') { if (!$this->check_hash()) { exit; } $tax_enabled = true; if (function_exists('wc_tax_enabled')) { $tax_enabled = wc_tax_enabled(); } else { $tax_enabled = get_option('woocommerce_calc_taxes') === 'yes'; } if ($tax_enabled) { $rates = $wpdb->get_results("SELECT tax_rate_country AS country, tax_rate_state AS state, tax_rate AS rate, tax_rate_name AS name, tax_rate_class AS class, tax_rate_order AS sequence, tax_rate_priority AS priority FROM `{$wpdb->prefix}woocommerce_tax_rates` ORDER BY tax_rate_order"); } else { $rates = array(); } $response = array('ack' => 'ok', 'tax_rates' => $rates); $this->sendHttpHeaders('200 OK', array('Content-Type' => 'application/json', 'Cache-Control' => 'no-cache, no-store', 'Expires' => 'Thu, 01 Jan 1970 00:00:00 GMT', 'Pragma' => 'no-cache')); echo $this->json_encode($response); exit; } else { if ($type === 'products') { if (!$this->check_hash()) { exit; } $page = isset($_GET['page']) ? (int) $_GET['page'] : 0; $count = isset($_GET['count']) ? (int) $_GET['count'] : 0; $product_ids = isset($_GET['product_ids']) ? json_decode(wp_unslash($_GET['product_ids'])) : null; if (!is_null($product_ids)) { if (!is_array($product_ids)) { $product_ids = array($product_ids); } $product_ids = array_filter($product_ids, create_function('$v', 'return is_numeric($v);')); if (!isset($_GET['count'])) { $count = count($product_ids); } } $products = $wpdb->get_results($wpdb->prepare("SELECT id AS id " . "FROM `{$wpdb->prefix}posts` AS P " . "WHERE post_type = 'product' " . "\t\tAND post_status IN ('publish', 'future', 'pending', 'private') " . "\t" . (is_array($product_ids) ? 'AND id IN (' . implode(',', $product_ids) . ')' : '') . "" . "ORDER BY ID LIMIT %d, %d", $page * $count, $count)); if (!is_array($product_ids) && $page === 0) { $total_count = $wpdb->get_var("SELECT COUNT(*) FROM `{$wpdb->prefix}posts` WHERE post_type = 'product' AND post_status IN ('publish', 'future', 'pending', 'private')"); } $acf_installed = function_exists('acf'); foreach ($products as $product) { $wc_product = $this->get_product($product->id); $categoryproduct = $wc_product->get_categories(); $product->sku = $wc_product->get_sku(); $product->name = html_entity_decode(apply_filters('woocommerce_product_title', $wc_product->post->post_title, $wc_product), ENT_COMPAT | ENT_HTML401, 'UTF-8'); $product->enabled = $wc_product->is_purchasable() && ($wc_product->managing_stock() || $wc_product->is_in_stock()); $product->price = $wc_product->get_price_excluding_tax(); $product->listprice = floatval($wc_product->get_regular_price()); $product->is_taxable = $wc_product->is_taxable(); $product->tax_class = $wc_product->get_tax_class(); $product->stock_control = $wc_product->managing_stock(); $product->stock_level = $wc_product->get_stock_quantity(); if (method_exists($wc_product, 'get_type')) { $product->type = $wc_product->get_type(); } else { $product->type = $wc_product->product_type; } $product->description = apply_filters('the_content', $wc_product->post->post_content); $product->short_description = apply_filters('the_content', $wc_product->post->post_excerpt); if (method_exists($wc_product, 'get_width')) { $product->width = $wc_product->get_width(); if (!is_numeric($product->width)) { unset($product->width); } $product->height = $wc_product->get_height(); if (!is_numeric($product->height)) { unset($product->height); } $product->length = $wc_product->get_length(); if (!is_numeric($product->length)) { unset($product->length); } } else { $product->length = $wc_product->length; $product->width = $wc_product->width; $product->height = $wc_product->height; } $product->weight = $wc_product->get_weight(); if (!is_numeric($product->weight)) { unset($product->weight); } if ($product->is_taxable && 'yes' === get_option('woocommerce_prices_include_tax')) { $tax_rates = WC_Tax::get_shop_base_rate($product->tax_class); $taxes = WC_Tax::calc_tax($product->listprice, $tax_rates, true); $product->listprice = $product->listprice - array_sum($taxes); } if ($product->type == 'variable') { $product->skus = array(); foreach ($wc_product->get_children() as $child_id) { $child_product = $wc_product->get_child($child_id); $img = wp_get_attachment_image_src($child_product->get_image_id(), 'full'); $img = $img[0]; $child_product_data = array('id' => $child_id, 'sku' => $child_product->get_sku(), 'enabled' => $wc_product->is_purchasable() && ($wc_product->managing_stock() || $wc_product->is_in_stock()), 'price' => $child_product->get_price_excluding_tax(), 'listprice' => $child_product->get_regular_price(), 'is_taxable' => $child_product->is_taxable(), 'tax_class' => $child_product->get_tax_class(), 'stock_control' => $child_product->managing_stock(), 'stock_level' => $child_product->get_stock_quantity(), 'images' => array(array('source' => $img, 'sequence' => 0))); $attributes = array(); $termsmap = array(); $names = array(); foreach ($child_product->get_variation_attributes() as $name => $value) { $name = preg_replace('/(pa_)?attribute_/', '', $name); if (!isset($names[$name])) { $names[$name] = true; $terms = get_terms(array('taxonomy' => $name)); if ($terms) { foreach ($terms as $term) { $termsmap[$term->slug] = $term->name; } } } if ($value && (gettype($value) == 'string' || gettype($value) == 'integer')) { if (array_key_exists($value, $termsmap)) { $newvalue = $termsmap[$value]; } else { $newvalue = $value; } } else { $newvalue = ''; } $name = wc_attribute_label($name, $child_product); $attributes[] = array('name' => $name, 'value' => $newvalue, 'slug' => $value); } foreach (get_post_custom_keys($child_product->variation_id) as $attribute) { if (!(in_array($attribute, array('_sku', '_weight', '_length', '_width', '_height', '_thumbnail_id', '_virtual', '_downloadable', '_regular_price', '_sale_price', '_sale_price_dates_from', '_sale_price_dates_to', '_price', '_download_limit', '_download_expiry', '_file_paths', '_manage_stock', '_stock_status', '_downloadable_files', '_variation_description', '_tax_class', '_tax_status', '_stock', '_default_attributes', '_product_attributes', '_file_path', '_backorders')) || substr($attribute, 0, 4) === '_wp_' || substr($attribute, 0, 13) === 'attribute_pa_')) { $value = get_post_meta($child_product->variation_id, $attribute, false); if (is_array($value)) { if (count($value) === 1) { $value = $value[0]; } else { $value = implode(',', $value); } } $attributes[] = array('name' => $attribute, 'value' => $value, 'custom' => true); } } $child_product_data['attributes'] = $attributes; $product->skus[] = $child_product_data; } $attrs = array(); foreach ($wc_product->get_variation_attributes() as $name => $value) { $name = preg_replace('/(pa_)?attribute_/', '', $name); if (!isset($names[$name])) { $names[$name] = true; $terms = get_terms(array('taxonomy' => $name)); if ($terms) { foreach ($terms as $term) { $termsmap[$term->slug] = $term->name; } } } if ($value && (gettype($value) == 'string' || gettype($value) == 'integer')) { if (array_key_exists($value, $termsmap)) { $newvalue = $termsmap[$value]; } else { $newvalue = $value; } } else { $newvalue = ''; } $name = wc_attribute_label($name, $child_product); $attrs[] = array('name' => $name, 'value' => $newvalue, 'slug' => $value); } $product->options = $attrs; } else { if ($product->type == 'grouped') { $product->skus = array(); foreach ($wc_product->get_children() as $child_id) { $child_product = $wc_product->get_child($child_id); $child_product_data = array('id' => $child_id, 'price' => $child_product->get_price_excluding_tax(), 'sku' => $child_product->get_sku(), 'name' => $child_product->get_title()); $product->skus[] = $child_product_data; } } } $product->categories = array(); $product_categories = get_the_terms($product->id, 'product_cat'); if (is_array($product_categories)) { $sequence = 0; foreach ($product_categories as $category) { $product->categories[] = array('category_id' => $category->term_id, 'sequence' => $sequence); $sequence++; } } $image_sequence = 1; $product->images = array(); $imagesUsed = array(); $primaryimage_path = wp_get_attachment_image_src($wc_product->get_image_id(), 'full'); $primaryimage_path = $primaryimage_path[0]; if ($primaryimage_path) { $product->images[] = array('source' => $primaryimage_path, 'sequence' => 0); $imagesUsed[$primaryimage_path] = true; foreach ($wc_product->get_gallery_attachment_ids() as $image_id) { $image_path = wp_get_attachment_image_src($image_id, 'full'); $image_path = $image_path[0]; if (!array_key_exists($image_path, $imagesUsed)) { $product->images[] = array('source' => $image_path, 'sequence' => $image_sequence); $imagesUsed[$image_path] = true; $image_sequence++; } } } $product->attributes = array(); $attributesUsed = array(); foreach ($wc_product->get_attributes() as $attribute) { if (!$attribute['is_variation']) { if (!array_key_exists($attribute['name'], $attributesUsed)) { $attributesUsed[$attribute['name']] = true; $attributeName = wc_attribute_label($attribute['name']); if (!$attribute['is_taxonomy']) { $product->attributes[] = array('name' => $attributeName, 'value' => $attribute['value']); } else { $attributeValue = implode(', ', wc_get_product_terms($product->id, $attribute['name'], array('fields' => 'names'))); $product->attributes[] = array('name' => $attributeName, 'value' => $attributeValue); } } } } foreach (get_post_custom_keys($product->id) as $attribute) { if (!(substr($attribute, 0, 1) === '_' || substr($attribute, 0, 3) === 'pa_')) { if (!array_key_exists($attribute, $attributesUsed)) { $attributesUsed[$attribute] = true; $value = get_post_meta($product->id, $attribute, false); if (is_array($value)) { if (count($value) === 1) { $value = $value[0]; } else { $value = implode(',', $value); } } $product->attributes[] = array('name' => $attribute, 'value' => $value); } } } // acf if ($acf_installed) { if (function_exists('get_field_objects')) { $fields = get_field_objects($product->id); if (is_array($fields)) { foreach ($fields as $field) { if ($field['type'] == 'image') { $image_path = $field['value']['url']; if (!array_key_exists($image_path, $imagesUsed)) { $product->images[] = array('source' => $image_path, 'sequence' => $image_sequence); $imagesUsed[$image_path] = true; $image_sequence++; } } else { if ($field['type'] == 'gallery') { $gallery = $field['value']; if (is_array($gallery)) { foreach ($gallery as $image) { $image_path = $image['url']; if (!array_key_exists($image_path, $imagesUsed)) { $product->images[] = array('source' => $image_path, 'sequence' => $image_sequence); $imagesUsed[$image_path] = true; $image_sequence++; } } } } else { if (in_array($field['type'], array('textarea', 'wysiwyg', 'text', 'number', 'select', 'radio', 'checkbox', 'true_false'))) { if (!array_key_exists($field['label'], $attributesUsed)) { $attributesUsed[$field['label']] = true; $value = $field['value']; if (is_array($value)) { if (count($value) === 1) { $value = $value[0]; } else { $value = implode(',', $value); } } $product->attributes[] = array('name' => $field['name'], 'value' => $value); } } } } if (!$product->description) { if (in_array($field['type'], array('textarea', 'wysiwyg')) && $field['name'] == 'description') { $product->description = $field['value']; } } } } } } } $response = array('ack' => 'ok', 'products' => $products); if (isset($total_count)) { $response['total_count'] = $total_count; } $this->sendHttpHeaders('200 OK', array('Content-Type' => 'application/json', 'Cache-Control' => 'no-cache, no-store', 'Expires' => 'Thu, 01 Jan 1970 00:00:00 GMT', 'Pragma' => 'no-cache')); echo $this->json_encode($response); exit; } else { if ($type === 'categories') { if (!$this->check_hash()) { exit; } $categories = get_categories(array('taxonomy' => 'product_cat', 'orderby' => 'term_order', 'hide_empty' => 0)); $result = array(); foreach ($categories as $category) { $result[] = array('category_id' => $category->term_id, 'name' => $category->name, 'parent_id' => $category->parent); } $response = array('ack' => 'ok', 'categories' => $result, 'total_count' => count($categories)); $this->sendHttpHeaders('200 OK', array('Content-Type' => 'application/json', 'Cache-Control' => 'no-cache, no-store', 'Expires' => 'Thu, 01 Jan 1970 00:00:00 GMT', 'Pragma' => 'no-cache')); echo $this->json_encode($response); exit; } else { if ($type === 'orders') { if (!$this->check_hash()) { exit; } $page = isset($_GET['page']) ? (int) $_GET['page'] : 0; $count = isset($_GET['count']) ? (int) $_GET['count'] : 0; $orders = $wpdb->get_results($wpdb->prepare("SELECT (SELECT meta_value FROM `{$wpdb->prefix}postmeta` WHERE post_id = P.id AND meta_key = '_codisto_orderid') AS id, ID AS post_id, post_status AS status FROM `{$wpdb->prefix}posts` AS P WHERE post_type = 'shop_order' AND ID IN (SELECT post_id FROM `{$wpdb->prefix}postmeta` WHERE meta_key = '_codisto_orderid') ORDER BY ID LIMIT %d, %d", $page * $count, $count)); if ($page == 0) { $total_count = $wpdb->get_var("SELECT COUNT(*) FROM `{$wpdb->prefix}posts` AS P WHERE post_type = 'shop_order' AND ID IN (SELECT post_id FROM `{$wpdb->prefix}postmeta` WHERE meta_key = '_codisto_orderid')"); } $order_data = array(); foreach ($orders as $order) { $ship_date = get_post_meta($order->post_id, '_date_shipped', true); if ($ship_date) { if (is_numeric($ship_date)) { $ship_date = date('Y-m-d H:i:s', $ship_date); } $order->ship_date = $ship_date; } $carrier = get_post_meta($order->post_id, '_tracking_provider', true); if ($carrier) { if ($carrier === 'custom') { $carrier = get_post_meta($order->post_id, '_custom_tracking_provider', true); } if ($carrier) { $order->carrier = $carrier; } } $tracking_number = get_post_meta($order->post_id, '_tracking_number', true); if ($tracking_number) { $order->track_number = $tracking_number; } unset($order->post_id); $order_data[] = $order; } $response = array('ack' => 'ok', 'orders' => $order_data); if (isset($total_count)) { $response['total_count'] = $total_count; } $this->sendHttpHeaders('200 OK', array('Content-Type' => 'application/json', 'Cache-Control' => 'no-cache, no-store', 'Expires' => 'Thu, 01 Jan 1970 00:00:00 GMT', 'Pragma' => 'no-cache')); echo $this->json_encode($response); exit; } else { if ($type == 'sync') { if ($_SERVER['HTTP_X_ACTION'] === 'TEMPLATE') { if (!$this->check_hash()) { exit; } $ebayDesignDir = WP_CONTENT_DIR . '/ebay/'; $merchantid = (int) $_GET['merchantid']; if (!$merchantid) { $merchantid = 0; } $templatedb = get_temp_dir() . '/ebay-template-' . $merchantid . '.db'; $db = new PDO('sqlite:' . $templatedb); $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); $db->setAttribute(PDO::ATTR_TIMEOUT, 60); $db->exec('PRAGMA synchronous=0'); $db->exec('PRAGMA temp_store=2'); $db->exec('PRAGMA page_size=65536'); $db->exec('PRAGMA encoding=\'UTF-8\''); $db->exec('PRAGMA cache_size=15000'); $db->exec('PRAGMA soft_heap_limit=67108864'); $db->exec('PRAGMA journal_mode=MEMORY'); $db->exec('BEGIN EXCLUSIVE TRANSACTION'); $db->exec('CREATE TABLE IF NOT EXISTS File(Name text NOT NULL PRIMARY KEY, Content blob NOT NULL, LastModified datetime NOT NULL, Changed bit NOT NULL DEFAULT -1)'); $db->exec('COMMIT TRANSACTION'); if (isset($_GET['markreceived'])) { $update = $db->prepare('UPDATE File SET LastModified = ? WHERE Name = ?'); $files = $db->query('SELECT Name FROM File WHERE Changed != 0'); $files->execute(); $db->exec('BEGIN EXCLUSIVE TRANSACTION'); while ($row = $files->fetch()) { $stat = stat(WP_CONTENT_DIR . '/ebay/' . $row['Name']); $lastModified = strftime('%Y-%m-%d %H:%M:%S', $stat['mtime']); $update->bindParam(1, $lastModified); $update->bindParam(2, $row['Name']); $update->execute(); } $db->exec('UPDATE File SET Changed = 0'); $db->exec('COMMIT TRANSACTION'); $db = null; $this->sendHttpHeaders('200 OK', array('Content-Type' => 'application/json', 'Cache-Control' => 'no-cache, must-revalidate', 'Expires' => 'Thu, 01 Jan 1970 00:00:00 GMT', 'Pragma' => 'no-cache')); echo $this->json_encode(array('ack' => 'ok')); exit; } else { $insert = $db->prepare('INSERT OR IGNORE INTO File(Name, Content, LastModified) VALUES (?, ?, ?)'); $update = $db->prepare('UPDATE File SET Content = ?, Changed = -1 WHERE Name = ? AND LastModified != ?'); $filelist = $this->files_in_dir($ebayDesignDir); $db->exec('BEGIN EXCLUSIVE TRANSACTION'); foreach ($filelist as $key => $name) { try { $fileName = $ebayDesignDir . $name; if (!in_array($name, array('README'))) { $content = @file_get_contents($fileName); if ($content !== false) { $stat = stat($fileName); $lastModified = strftime('%Y-%m-%d %H:%M:%S', $stat['mtime']); $update->bindParam(1, $content); $update->bindParam(2, $name); $update->bindParam(3, $lastModified); $update->execute(); if ($update->rowCount() == 0) { $insert->bindParam(1, $name); $insert->bindParam(2, $content); $insert->bindParam(3, $lastModified); $insert->execute(); } } } } catch (Exception $e) { } } $db->exec('COMMIT TRANSACTION'); $tmpDb = wp_tempnam(); $db = new PDO('sqlite:' . $tmpDb); $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); $db->exec('PRAGMA synchronous=0'); $db->exec('PRAGMA temp_store=2'); $db->exec('PRAGMA page_size=512'); $db->exec('PRAGMA encoding=\'UTF-8\''); $db->exec('PRAGMA cache_size=15000'); $db->exec('PRAGMA soft_heap_limit=67108864'); $db->exec('PRAGMA journal_mode=OFF'); $db->exec('ATTACH DATABASE \'' . $templatedb . '\' AS Source'); $db->exec('CREATE TABLE File AS SELECT * FROM Source.File WHERE Changed != 0'); $db->exec('DETACH DATABASE Source'); $db->exec('VACUUM'); $fileCountStmt = $db->query('SELECT COUNT(*) AS fileCount FROM File'); $fileCountStmt->execute(); $fileCountRow = $fileCountStmt->fetch(); $fileCount = $fileCountRow['fileCount']; $db = null; if ($fileCount == 0) { $this->sendHttpHeaders('204 No Content', array('Cache-Control' => 'no-cache, must-revalidate', 'Expires' => 'Thu, 01 Jan 1970 00:00:00 GMT', 'Pragma' => 'no-cache')); } else { $headers = array('Cache-Control' => 'no-cache, must-revalidate', 'Pragma' => 'no-cache', 'Expires' => 'Thu, 01 Jan 1970 00:00:00 GMT', 'Content-Type' => 'application/octet-stream', 'Content-Disposition' => 'attachment; filename=' . basename($tmpDb), 'Content-Length' => filesize($tmpDb)); $this->sendHttpHeaders('200 OK', $headers); while (ob_get_level() > 0) { if (!@ob_end_clean()) { break; } } flush(); readfile($tmpDb); } unlink($tmpDb); exit; } } } } } } } } } } else { if ($type === 'createorder') { if (!$this->check_hash()) { exit; } try { $xml = simplexml_load_string(file_get_contents('php://input')); $ordercontent = $xml->entry->content->children('http://api.codisto.com/schemas/2009/'); $wpdb->query('SET TRANSACTION ISOLATION LEVEL SERIALIZABLE'); $wpdb->query('START TRANSACTION'); $billing_address = $ordercontent->orderaddresses->orderaddress[0]; $shipping_address = $ordercontent->orderaddresses->orderaddress[1]; $billing_first_name = $billing_last_name = ''; if (strpos($billing_address->name, ' ') !== false) { $billing_name = explode(' ', $billing_address->name, 2); $billing_first_name = $billing_name[0]; $billing_last_name = $billing_name[1]; } else { $billing_first_name = (string) $billing_address->name; } $billing_country_code = (string) $billing_address->countrycode; $billing_division = (string) $billing_address->division; $billing_states = WC()->countries->get_states($billing_country_code); if ($billing_states) { $billing_division_match = preg_replace('/\\s+/', '', strtolower($billing_division)); foreach ($billing_states as $state_code => $state_name) { if (preg_replace('/\\s+/', '', strtolower($state_name)) == $billing_division_match) { $billing_division = $state_code; break; } } } $shipping_first_name = $shipping_last_name = ''; if (strpos($shipping_address->name, ' ') !== false) { $shipping_name = explode(' ', $shipping_address->name, 2); $shipping_first_name = $shipping_name[0]; $shipping_last_name = $shipping_name[1]; } else { $shipping_first_name = (string) $shipping_address->name; } $shipping_country_code = (string) $shipping_address->countrycode; $shipping_division = (string) $shipping_address->division; if ($billing_country_code === $shipping_country_code) { $shipping_states = $billing_states; } else { $shipping_states = WC()->countries->get_states($shipping_country_code); } if ($shipping_states) { $shipping_division_match = preg_replace('/\\s+/', '', strtolower($shipping_division)); foreach ($shipping_states as $state_code => $state_name) { if (preg_replace('/\\s+/', '', strtolower($state_name)) == $shipping_division_match) { $shipping_division = $state_code; break; } } } $address_data = array('billing_first_name' => $billing_first_name, 'billing_last_name' => $billing_last_name, 'billing_company' => (string) $billing_address->companyname, 'billing_address_1' => (string) $billing_address->address1, 'billing_address_2' => (string) $billing_address->address2, 'billing_city' => (string) $billing_address->place, 'billing_postcode' => (string) $billing_address->postalcode, 'billing_state' => $billing_division, 'billing_country' => $billing_country_code, 'billing_email' => (string) $billing_address->email, 'billing_phone' => (string) $billing_address->phone, 'shipping_first_name' => $shipping_first_name, 'shipping_last_name' => $shipping_last_name, 'shipping_company' => (string) $shipping_address->companyname, 'shipping_address_1' => (string) $shipping_address->address1, 'shipping_address_2' => (string) $shipping_address->address2, 'shipping_city' => (string) $shipping_address->place, 'shipping_postcode' => (string) $shipping_address->postalcode, 'shipping_state' => $shipping_division, 'shipping_country' => $shipping_country_code, 'shipping_email' => (string) $shipping_address->email, 'shipping_phone' => (string) $shipping_address->phone); $email = (string) $billing_address->email; if (!$email) { $email = (string) $shipping_address->email; } if ($email) { $user = get_user_by('email', $email); if (!$user) { $username = (string) $ordercontent->ebayusername; if (!$username) { $username = current(explode('@', $email)); } if ($username) { $username = sanitize_user($username); } if (username_exists($username)) { $counter = 1; $newusername = $username . $counter; while (username_exists($newusername)) { $counter++; $newusername = $username . $counter; } $username = $newusername; } $password = wp_generate_password(); $customer_data = apply_filters('woocommerce_new_customer_data', array('user_login' => $username, 'user_pass' => $password, 'user_email' => $email, 'role' => 'customer')); $customer_id = wp_insert_user($customer_data); foreach ($address_data as $key => $value) { update_user_meta($customer_id, $key, $value); } do_action('woocommerce_created_customer', $customer_id, $customer_data, true); } else { $customer_id = $user->ID; } } else { $customer_id = 0; } $customer_note = @count($ordercontent->instructions) ? strval($ordercontent->instructions) : ''; $order_id = $wpdb->get_var($wpdb->prepare("SELECT ID FROM `{$wpdb->prefix}posts` AS P WHERE ID IN (SELECT post_id FROM `{$wpdb->prefix}postmeta` WHERE meta_key = '_codisto_orderid' AND meta_value = %d)", (int) $ordercontent->orderid)); $shipping = 0; $shipping_tax = 0; $cart_discount = 0; $cart_discount_tax = 0; $total = (double) $ordercontent->ordertotal; $tax = 0; if (!$order_id) { $new_order_data_callback = array($this, 'order_set_date'); add_filter('woocommerce_new_order_data', $new_order_data_callback, 1, 1); $order = wc_create_order(array('customer_id' => $customer_id, 'customer_note' => $customer_note, 'created_via' => 'eBay')); remove_filter('woocommerce_new_order_data', $new_order_data_callback); $order_id = $order->id; update_post_meta($order_id, '_codisto_orderid', (int) $ordercontent->orderid); update_post_meta($order_id, '_codisto_ebayuser', (string) $ordercontent->ebayusername); update_post_meta($order_id, '_order_currency', (string) $ordercontent->transactcurrency); update_post_meta($order_id, '_customer_ip_address', '-'); delete_post_meta($order_id, '_prices_include_tax'); do_action('woocommerce_new_order', $order_id); foreach ($ordercontent->orderlines->orderline as $orderline) { if ($orderline->productcode[0] != 'FREIGHT') { $productcode = (string) $orderline->productcode; if ($productcode == null) { $productcode = ''; } $productname = (string) $orderline->productname; if ($productname == null) { $productname = ''; } $product_id = $orderline->externalreference[0]; if ($product_id != null) { $product_id = intval($product_id); } $variation_id = 0; if (get_post_type($product_id) === 'product_variation') { $variation_id = $product_id; $product_id = wp_get_post_parent_id($variation_id); if (!is_numeric($product_id) || $product_id === 0) { $product_id = 0; $variation_id = 0; } } $qty = (int) $orderline->quantity[0]; $item_id = wc_add_order_item($order_id, array('order_item_name' => $productname, 'order_item_type' => 'line_item')); wc_add_order_item_meta($item_id, '_qty', $qty); if (!is_null($product_id) && $product_id !== 0) { wc_add_order_item_meta($item_id, '_product_id', $product_id); wc_add_order_item_meta($item_id, '_variation_id', $variation_id); wc_add_order_item_meta($item_id, '_tax_class', ''); } else { wc_add_order_item_meta($item_id, '_product_id', 0); wc_add_order_item_meta($item_id, '_variation_id', 0); wc_add_order_item_meta($item_id, '_tax_class', ''); } $line_total = wc_format_decimal((double) $orderline->linetotal); $line_total_tax = wc_format_decimal((double) $orderline->linetotalinctax - (double) $orderline->linetotal); wc_add_order_item_meta($item_id, '_line_subtotal', $line_total); wc_add_order_item_meta($item_id, '_line_total', $line_total); wc_add_order_item_meta($item_id, '_line_subtotal_tax', $line_total_tax); wc_add_order_item_meta($item_id, '_line_tax', $line_total_tax); wc_add_order_item_meta($item_id, '_line_tax_data', array('total' => array(1 => $line_total_tax), 'subtotal' => array(1 => $line_total_tax))); $tax += $line_total_tax; } else { $item_id = wc_add_order_item($order_id, array('order_item_name' => (string) $orderline->productname, 'order_item_type' => 'shipping')); wc_add_order_item_meta($item_id, 'cost', wc_format_decimal((double) $orderline->linetotal)); $shipping += (double) $orderline->linetotal; $shipping_tax += (double) $orderline->linetotalinctax - (double) $orderline->linetotal; } } if ($ordercontent->paymentstatus == 'complete') { $transaction_id = (string) $ordercontent->orderpayments[0]->orderpayment->transactionid; if ($transaction_id) { update_post_meta($order_id, '_payment_method', 'paypal'); update_post_meta($order_id, '_payment_method_title', __('PayPal', 'woocommerce')); update_post_meta($order_id, '_transaction_id', $transaction_id); } else { update_post_meta($order_id, '_payment_method', 'bacs'); update_post_meta($order_id, '_payment_method_title', __('BACS', 'woocommerce')); } // payment_complete add_post_meta($order_id, '_paid_date', current_time('mysql'), true); if (!get_post_meta($order_id, '_order_stock_reduced', true)) { $order->reduce_order_stock(); } } } else { $order = wc_get_order($order_id); foreach ($ordercontent->orderlines->orderline as $orderline) { if ($orderline->productcode[0] != 'FREIGHT') { $line_total = wc_format_decimal((double) $orderline->linetotal); $line_total_tax = wc_format_decimal((double) $orderline->linetotalinctax - (double) $orderline->linetotal); $tax += $line_total_tax; } else { $order->remove_order_items('shipping'); $item_id = wc_add_order_item($order_id, array('order_item_name' => (string) $orderline->productname, 'order_item_type' => 'shipping')); wc_add_order_item_meta($item_id, 'cost', wc_format_decimal((double) $orderline->linetotal)); $shipping += (double) $orderline->linetotal; $shipping_tax += (double) $orderline->linetotalinctax - (double) $orderline->linetotal; } } if ($ordercontent->paymentstatus == 'complete') { $transaction_id = (string) $ordercontent->orderpayments[0]->orderpayment->transactionid; if ($transaction_id) { update_post_meta($order_id, '_payment_method', 'paypal'); update_post_meta($order_id, '_payment_method_title', __('PayPal', 'woocommerce')); update_post_meta($order_id, '_transaction_id', $transaction_id); } else { update_post_meta($order_id, '_payment_method', 'bacs'); update_post_meta($order_id, '_payment_method_title', __('BACS', 'woocommerce')); } // payment_complete add_post_meta($order_id, '_paid_date', current_time('mysql'), true); if (!get_post_meta($order_id, '_order_stock_reduced', true)) { $order->reduce_order_stock(); } } } foreach ($address_data as $key => $value) { update_post_meta($order_id, '_' . $key, $value); } $order->remove_order_items('tax'); $order->add_tax(1, $tax, $shipping_tax); $order->set_total($shipping, 'shipping'); $order->set_total($shipping_tax, 'shipping_tax'); $order->set_total($cart_discount, 'cart_discount'); $order->set_total($cart_discount_tax, 'cart_discount_tax'); $order->set_total($tax, 'tax'); $order->set_total($total, 'total'); if ($ordercontent->orderstate == 'cancelled') { if (!$order->has_status('cancelled')) { // update_status $order->post_status = 'wc-cancelled'; $update_post_data = array('ID' => $order_id, 'post_status' => 'wc-cancelled', 'post_date' => current_time('mysql', 0), 'post_date_gmt' => current_time('mysql', 1)); wp_update_post($update_post_data); $order->decrease_coupon_usage_counts(); wc_delete_shop_order_transients($order_id); } } else { if ($ordercontent->orderstate == 'inprogress' || $ordercontent->orderstate == 'processing') { if ($ordercontent->paymentstatus == 'complete') { if (!$order->has_status('processing')) { // update_status $order->post_status = 'wc-processing'; $update_post_data = array('ID' => $order_id, 'post_status' => 'wc-processing', 'post_date' => current_time('mysql', 0), 'post_date_gmt' => current_time('mysql', 1)); wp_update_post($update_post_data); } } else { if (!$order->has_status('pending')) { // update_status $order->post_status = 'wc-pending'; $update_post_data = array('ID' => $order_id, 'post_status' => 'wc-pending', 'post_date' => current_time('mysql', 0), 'post_date_gmt' => current_time('mysql', 1)); wp_update_post($update_post_data); } } } else { if ($ordercontent->orderstate == 'complete') { if (!$order->has_status('completed')) { // update_status $order->post_status = 'wc-completed'; $update_post_data = array('ID' => $order_id, 'post_status' => 'wc-completed', 'post_date' => current_time('mysql', 0), 'post_date_gmt' => current_time('mysql', 1)); wp_update_post($update_post_data); $order->record_product_sales(); $order->increase_coupon_usage_counts(); update_post_meta($order_id, '_completed_date', current_time('mysql')); wc_delete_shop_order_transients($order_id); } } } } $wpdb->query('COMMIT'); $response = array('ack' => 'ok', 'orderid' => $order_id); $this->sendHttpHeaders('200 OK', array('Content-Type' => 'application/json', 'Cache-Control' => 'no-cache, no-store', 'Expires' => 'Thu, 01 Jan 1970 00:00:00 GMT', 'Pragma' => 'no-cache')); echo $this->json_encode($response); exit; } catch (Exception $e) { $wpdb->query('ROLLBACK'); $response = array('ack' => 'failed', 'message' => $e->getMessage() . ' ' . $e->getFile() . ' ' . $e->getLine()); $this->sendHttpHeaders('200 OK', array('Content-Type' => 'application/json', 'Cache-Control' => 'no-cache, no-store', 'Expires' => 'Thu, 01 Jan 1970 00:00:00 GMT', 'Pragma' => 'no-cache')); echo $this->json_encode($response); exit; } } else { if ($type == 'sync') { if ($_SERVER['HTTP_X_ACTION'] === 'TEMPLATE') { if (!$this->check_hash()) { exit; } $ebayDesignDir = WP_CONTENT_DIR . '/ebay/'; $tmpPath = wp_tempnam(); @file_put_contents($tmpPath, file_get_contents('php://input')); $db = new PDO('sqlite:' . $tmpPath); $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); $db->exec('PRAGMA synchronous=0'); $db->exec('PRAGMA temp_store=2'); $db->exec('PRAGMA page_size=65536'); $db->exec('PRAGMA encoding=\'UTF-8\''); $db->exec('PRAGMA cache_size=15000'); $db->exec('PRAGMA soft_heap_limit=67108864'); $db->exec('PRAGMA journal_mode=MEMORY'); $files = $db->prepare('SELECT Name, Content FROM File'); $files->execute(); $files->bindColumn(1, $name); $files->bindColumn(2, $content); while ($files->fetch()) { $fileName = $ebayDesignDir . $name; if (strpos($name, '..') === false) { if (!file_exists($fileName)) { $dir = dirname($fileName); if (!is_dir($dir)) { mkdir($dir . '/', 0755, true); } @file_put_contents($fileName, $content); } } } $db = null; unlink($tmpPath); $this->sendHttpHeaders('200 OK', array('Content-Type' => 'application/json', 'Cache-Control' => 'no-cache, no-store', 'Expires' => 'Thu, 01 Jan 1970 00:00:00 GMT', 'Pragma' => 'no-cache')); echo $this->json_encode(array('ack' => 'ok')); exit; } } else { if ($type == 'index/calc') { $product_ids = array(); $quantities = array(); for ($i = 0;; $i++) { if (!isset($_POST['PRODUCTCODE(' . $i . ')'])) { break; } $productid = (int) $_POST['PRODUCTID(' . $i . ')']; if (!$productid) { $productcode = $_POST['PRODUCTCODE(' . $i . ')']; $productid = wc_get_product_id_by_sku($productcode); } $productqty = $_POST['PRODUCTQUANTITY(' . $i . ')']; if (!$productqty && $productqty != 0) { $productqty = 1; } WC()->cart->add_to_cart($productid, $productqty); } WC()->customer->set_location($_POST['COUNTRYCODE'], $_POST['DIVISION'], $_POST['POSTALCODE'], $_POST['PLACE']); WC()->customer->set_shipping_location($_POST['COUNTRYCODE'], $_POST['DIVISION'], $_POST['POSTALCODE'], $_POST['PLACE']); WC()->cart->calculate_totals(); WC()->cart->calculate_shipping(); $response = ''; $idx = 0; $methods = WC()->shipping()->get_shipping_methods(); foreach ($methods as $method) { if (file_exists(plugin_dir_path(__FILE__) . 'shipping/' . $method->id)) { include plugin_dir_path(__FILE__) . 'shipping/' . $method->id; } else { foreach ($method->rates as $method => $rate) { $method_name = $rate->get_label(); if (!$method_name) { $method_name = 'Shipping'; } $method_cost = $rate->cost; if (is_numeric($method_cost)) { if (isset($rate->taxes) && is_array($rate->taxes)) { foreach ($rate->taxes as $tax) { if (is_numeric($tax)) { $method_cost += $tax; } } } $response .= ($idx > 0 ? '&' : '') . 'FREIGHTNAME(' . $idx . ')=' . rawurlencode($method_name) . '&FREIGHTCHARGEINCTAX(' . $idx . ')=' . number_format((double) $method_cost, 2, '.', ''); $idx++; } } } } $this->sendHttpHeaders('200 OK', array('Content-Type' => 'application/json', 'Cache-Control' => 'no-cache, no-store', 'Expires' => 'Thu, 01 Jan 1970 00:00:00 GMT', 'Pragma' => 'no-cache')); echo $response; exit; } } } } }
public function get_product_by_id($sku = null) { global $wpdb; $product_id = null; /* ! @since 3.0.6 use new function wc_get_product_id_by_sku to get SKU */ if (function_exists('wc_get_product_id_by_sku')) { $product_id = wc_get_product_id_by_sku($sku); } else { $product_id = $wpdb->get_var($wpdb->prepare("SELECT max(post_id) FROM {$wpdb->postmeta} a, {$wpdb->posts} b\n\t\t\t\tWHERE a.post_id= b.id and meta_key='_sku' AND meta_value='%s' LIMIT 1", $sku)); } if ($product_id) { $product['ID'] = $product_id; } return $product_id = apply_filters('woocsv_get_product_id', $product_id, $sku); }
/** * Create or update a line item * * @since 2.5.0 * @param WC_Order $order * @param array $item line item data * @param string $action 'create' to add line item or 'update' to update it * @throws WC_CLI_Exception invalid data, server error */ protected function set_line_item($order, $item, $action) { $creating = 'create' === $action; // product is always required if (!isset($item['product_id']) && !isset($item['sku'])) { throw new WC_CLI_Exception('woocommerce_cli_invalid_product_id', __('Product ID or SKU is required', 'woocommerce')); } // when updating, ensure product ID provided matches if ('update' === $action) { $item_product_id = wc_get_order_item_meta($item['id'], '_product_id'); $item_variation_id = wc_get_order_item_meta($item['id'], '_variation_id'); if ($item['product_id'] != $item_product_id && $item['product_id'] != $item_variation_id) { throw new WC_CLI_Exception('woocommerce_cli_invalid_product_id', __('Product ID provided does not match this line item', 'woocommerce')); } } if (isset($item['product_id'])) { $product_id = $item['product_id']; } elseif (isset($item['sku'])) { $product_id = wc_get_product_id_by_sku($item['sku']); } // variations must each have a key & value $variation_id = 0; if (isset($item['variations']) && is_array($item['variations'])) { foreach ($item['variations'] as $key => $value) { if (!$key || !$value) { throw new WC_CLI_Exception('woocommerce_cli_invalid_product_variation', __('The product variation is invalid', 'woocommerce')); } } $item_args['variation'] = $item['variations']; $variation_id = $this->get_variation_id(wc_get_product($product_id), $item_args['variation']); } $product = wc_get_product($variation_id ? $variation_id : $product_id); // must be a valid WC_Product if (!is_object($product)) { throw new WC_CLI_Exception('woocommerce_cli_invalid_product', __('Product is invalid.', 'woocommerce')); } // quantity must be positive float if (isset($item['quantity']) && floatval($item['quantity']) <= 0) { throw new WC_CLI_Exception('woocommerce_cli_invalid_product_quantity', __('Product quantity must be a positive float.', 'woocommerce')); } // quantity is required when creating if ($creating && !isset($item['quantity'])) { throw new WC_CLI_Exception('woocommerce_cli_invalid_product_quantity', __('Product quantity is required.', 'woocommerce')); } $item_args = array(); // quantity if (isset($item['quantity'])) { $item_args['qty'] = $item['quantity']; } // total if (isset($item['total'])) { $item_args['totals']['total'] = floatval($item['total']); } // total tax if (isset($item['total_tax'])) { $item_args['totals']['tax'] = floatval($item['total_tax']); } // subtotal if (isset($item['subtotal'])) { $item_args['totals']['subtotal'] = floatval($item['subtotal']); } // subtotal tax if (isset($item['subtotal_tax'])) { $item_args['totals']['subtotal_tax'] = floatval($item['subtotal_tax']); } $item_args = apply_filters('woocommerce_cli_order_line_item_args', $item_args, $item, $order, $action); if ($creating) { $item_id = $order->add_product($product, $item_args['qty'], $item_args); if (!$item_id) { throw new WC_CLI_Exception('woocommerce_cannot_create_line_item', __('Cannot create line item, try again.', 'woocommerce')); } } else { $item_id = $order->update_product($item['id'], $product, $item_args); if (!$item_id) { throw new WC_CLI_Exception('woocommerce_cannot_update_line_item', __('Cannot update line item, try again.', 'woocommerce')); } } }
/** * Test wc_get_product_id_by_sku() * * @since 2.3 */ public function test_wc_get_product_id_by_sku() { // Create product $product = \WC_Helper_Product::create_simple_product(); $this->assertEquals($product->id, wc_get_product_id_by_sku($product->sku)); // Delete Product \WC_Helper_Product::delete_product($product->id); }
public function get_product_sku($skus = array()) { $return = array(); foreach ($skus as $sku) { if (empty($sku)) { continue; } $return[] = wc_get_product_id_by_sku($sku); } return $return; }
/** * Bulk update or insert products * Accepts an array with products in the formats supported by * WC_API_Products->create_product() and WC_API_Products->edit_product() * * @since 2.4.0 * @param array $data * @return array */ public function bulk($data) { try { if (!isset($data['products'])) { throw new WC_API_Exception('woocommerce_api_missing_products_data', sprintf(__('No %1$s data specified to create/edit %1$s', 'woocommerce'), 'products'), 400); } $data = $data['products']; $limit = apply_filters('woocommerce_api_bulk_limit', 100, 'products'); // Limit bulk operation if (count($data) > $limit) { throw new WC_API_Exception('woocommerce_api_products_request_entity_too_large', sprintf(__('Unable to accept more than %s items for this request', 'woocommerce'), $limit), 413); } $products = array(); foreach ($data as $_product) { $product_id = 0; $product_sku = ''; // Try to get the product ID if (isset($_product['id'])) { $product_id = intval($_product['id']); } if (!$product_id && isset($_product['sku'])) { $product_sku = wc_clean($_product['sku']); $product_id = wc_get_product_id_by_sku($product_sku); } // Product exists / edit product if ($product_id) { $edit = $this->edit_product($product_id, array('product' => $_product)); if (is_wp_error($edit)) { $products[] = array('id' => $product_id, 'sku' => $product_sku, 'error' => array('code' => $edit->get_error_code(), 'message' => $edit->get_error_message())); } else { $products[] = $edit['product']; } } else { $new = $this->create_product(array('product' => $_product)); if (is_wp_error($new)) { $products[] = array('id' => $product_id, 'sku' => $product_sku, 'error' => array('code' => $new->get_error_code(), 'message' => $new->get_error_message())); } else { $products[] = $new['product']; } } } return array('products' => apply_filters('woocommerce_api_products_bulk_response', $products, $this)); } catch (WC_API_Exception $e) { return new WP_Error($e->getErrorCode(), $e->getMessage(), array('status' => $e->getCode())); } }
/** * Create or update a line item. * * @param WC_Order $order Order data. * @param array $item Line item data. * @param string $action 'create' to add line item or 'update' to update it. * @throws WC_REST_Exception Invalid data, server error. */ protected function set_line_item($order, $item, $action = 'create') { $creating = 'create' === $action; $item_args = array(); // Product is always required. if (empty($item['product_id']) && empty($item['sku']) && empty($item['variation_id'])) { throw new WC_REST_Exception('woocommerce_rest_required_product_reference', __('Product ID or SKU is required.', 'woocommerce'), 400); } if (!empty($item['sku'])) { $product_id = (int) wc_get_product_id_by_sku($item['sku']); } elseif (!empty($item['product_id']) && empty($item['variation_id'])) { $product_id = (int) $item['product_id']; } elseif (!empty($item['variation_id'])) { $product_id = (int) $item['variation_id']; } // When updating, ensure product ID provided matches. if ('update' === $action && !empty($item['id'])) { $item_product_id = (int) wc_get_order_item_meta($item['id'], '_product_id'); $item_variation_id = (int) wc_get_order_item_meta($item['id'], '_variation_id'); if ($product_id !== $item_product_id && $product_id !== $item_variation_id) { throw new WC_REST_Exception('woocommerce_rest_required_product_reference', __('Product ID or variation ID provided does not match this line item.', 'woocommerce'), 400); } } $product = wc_get_product($product_id); // Must be a valid WC_Product. if (!is_object($product)) { throw new WC_REST_Exception('woocommerce_rest_invalid_product', __('Product is invalid.', 'woocommerce'), 400); } // Quantity must be positive float. if (isset($item['quantity']) && 0 >= floatval($item['quantity'])) { throw new WC_REST_Exception('woocommerce_rest_invalid_product_quantity', __('Product quantity must be a positive float.', 'woocommerce'), 400); } // Quantity is required when creating. if ($creating && !isset($item['quantity'])) { throw new WC_REST_Exception('woocommerce_rest_invalid_product_quantity', __('Product quantity is required.', 'woocommerce'), 400); } // Get variation attributes. if (method_exists($product, 'get_variation_attributes')) { $item_args['variation'] = $product->get_variation_attributes(); } // Quantity. if (isset($item['quantity'])) { $item_args['qty'] = $item['quantity']; } // Total. if (isset($item['total'])) { $item_args['totals']['total'] = floatval($item['total']); } // Total tax. if (isset($item['total_tax'])) { $item_args['totals']['tax'] = floatval($item['total_tax']); } // Subtotal. if (isset($item['subtotal'])) { $item_args['totals']['subtotal'] = floatval($item['subtotal']); } // Subtotal tax. if (isset($item['subtotal_tax'])) { $item_args['totals']['subtotal_tax'] = floatval($item['subtotal_tax']); } if ($creating) { $item_id = $order->add_product($product, $item_args['qty'], $item_args); if (!$item_id) { throw new WC_REST_Exception('woocommerce_rest_cannot_create_line_item', __('Cannot create line item, try again.', 'woocommerce'), 500); } } else { $item_id = $order->update_product($item['id'], $product, $item_args); if (!$item_id) { throw new WC_REST_Exception('woocommerce_rest_cannot_update_line_item', __('Cannot update line item, try again.', 'woocommerce'), 500); } } }