Add code in functions.php
add_action('rest_api_init', function () {
register_rest_route('wc/v3', '/products/last-update', array(
'methods' => 'GET',
'callback' => 'get_products_by_last_update',
'permission_callback' => 'is_user_logged_in', // Ensure the user is logged in
));
});
function get_products_by_last_update(WP_REST_Request $request) {
// Get pagination parameters
$paged = absint($request->get_param('page')) ?: 1;
$per_page = absint($request->get_param('per_page')) ?: 10;
$date_modified_after = $request->get_param('date_modified_after');
// Query arguments for fetching products
$args = array(
'status' => 'publish',
'limit' => $per_page, // Limit to the number of products per page
'page' => $paged, // Current page
);
// Validation
if (!empty($date_modified_after)) {
$args['date_modified'] = '>=' . $date_modified_after;
}
// Fetch products based on provided date
$products = wc_get_products($args);
// Prepare response data
$data = [];
if (!empty($products)) {
foreach ($products as $product) {
$product_data = array(
'id' => $product->get_id(),
'sku' => $product->get_sku(), // Get the SKU
'weight' => $product->get_weight(), // Get the SKU
'barcode' => get_post_meta($product->get_id(), '_barcode', true), // Fetch the barcode from post meta
'name' => $product->get_name(),
'price' => $product->get_regular_price(),
'sale_price' => $product->get_sale_price(), // Get sale price
'description' => $product->get_description(), // Get product description
'date_modified' => $product->get_date_modified()->date('c'),
'type' => $product->get_type(), // Get product type (simple or variable)
'brand' => '', // Fetching brand information
'url' => get_permalink($product->get_id()), // Get product permalink
'quantity' => $product->get_manage_stock() ? $product->get_stock_quantity() : 1000, // Logic for quantity
'availability' => $product->get_manage_stock() && $product->get_stock_quantity() <= 0 ? 'Out of Stock' : 'In Stock', // Determine availability
'categories' => [], // Initialize categories array
'images' => [], // Initialize images array
);
// Add main image
if ($product->get_image_id()) {
$product_data['images'][] = wp_get_attachment_url($product->get_image_id());
}
// Add gallery images
$gallery_image_ids = $product->get_gallery_image_ids();
foreach ($gallery_image_ids as $image_id) {
$product_data['images'][] = wp_get_attachment_url($image_id);
}
// Fetch categories for the product
$categories = get_the_terms($product->get_id(), 'product_cat'); // Fetch category terms for the product
if ($categories && !is_wp_error($categories)) {
$categories_array = [];
foreach ($categories as $category) {
// Only include the category if it is a leaf category (no children)
if (empty(get_term_children($category->term_id, 'product_cat'))) {
// Get parent category if it exists
$category_name_array = [];
if ($category->parent !== 0) {
$parent_category = get_term($category->parent, 'product_cat'); // Fetch parent category
if (!is_wp_error($parent_category) && $parent_category) {
$category_name_array[] = $parent_category->name;
// Check for grandparent
if ($parent_category->parent !== 0) {
$grandparent_category = get_term($parent_category->parent, 'product_cat');
if (!is_wp_error($grandparent_category) && $grandparent_category) {
$category_name_array[] = $grandparent_category->name; // Add the grandparent category name
}
}
}
}
$category_name_array[] = $category->name;
$categories_array[] = implode(' > ', $category_name_array);
}
}
$product_data['categories'] = implode(',', $categories_array);
}
// Check if the product is a variable product and include variations
if ($product->is_type('variable')) {
$product_data['allvariations'] = $product->get_available_variations();
$product_data['variations'] = []; // Initialize variations array
foreach ($product->get_available_variations() as $variation) {
// Prepare variation data
$variation_data = array(
'id' => $variation['variation_id'],
'sku' => $variation['sku'],
'price' => $variation['display_price'],
'sale_price' => $variation['display_regular_price'],
'quantity' => isset($variation['max_quantity']) ? $variation['max_quantity'] : 1000, // Stock quantity for the variation
'image' => isset($variation['image']['src']) ? $variation['image']['src'] : '', // Variation image URL
//'attributes' => []
);
foreach ($variation['attributes'] as $attribute => $value) {
$cleaned_attribute = str_replace('attribute_pa_', '', $attribute);
$variation_data['attributes'][] = array(
'name' => ucfirst($cleaned_attribute), // Get the pretty name for the attribute
'value' => $value, // The value of this attribute
);
}
$product_data['variations'][] = $variation_data;
}
}
else {
// For simple products, directly add attributes if available
if(count($product->get_attributes()) > 0){
$product_data['attributes'] = [];
foreach ($product->get_attributes() as $Key => $attribute) {
$product_data['attributes'][] = array(
'name' => ucwords(wc_attribute_label($attribute->get_name())), // This is the attribute name (e.g., "Color")
'options' => $attribute->get_options()
);
}
}
}
// Fetch brand information
$brands = get_the_terms($product->get_id(), 'product_brand'); // Fetch brand terms for the product
if ($brands && !is_wp_error($brands)) {
// Check if the brand exists and get the first one
$product_data['brand'] = !empty($brands) ? $brands[0]->name : '';
}
$data[] = $product_data;
}
}
// Prepare and return the response
return new WP_REST_Response(array(
'current_page' => $paged, // Current page number
'current_page' => $paged, // Current page number
'per_page' => $per_page, // Products per page
'date_modified_after' => $date_modified_after,
'products' => $data, // Products data
), 200);
}
Get Wordpress Credentials
- Login to Wordpress
- Woocommerce => Settings => Advanced
- Click the Rest API
- Click the Add key
- Copy the following:
- Wordpress URL: your website url
- Wordpress Customer Key: Newly created key
- Wordpress Secret Key: Newly created secret key
Fetch the Jinius API Key
https://help.jinius.com.cy/hc/en-us/articles/23333712658961-How-to-get-your-API-Key