Woocommerce import products from api. You can easily create a product in Woocommerce using Curl: See full list on wordpress. Step 3: Map the Incoming Data. Table of Contents. e. The next step is to accurately import WooCommerce Product Table simply lists your WooCommerce products in a table. json), import 100 products, remove them from temporary. Step 3: Click Choose File in the Import products by CSV file window. Once you have open the Import tool, you need to select these values to import a Google Sheet containing WooCommerce products data: Source: Google Sheets. Select Import. Click the export button to download a CSV of all product price and stock data. With the Migrate WooCommerce to Shopify plugin, you can import product data from WooCommerce to Shopify in just two simple steps included: Products, Categories, Tags, Slugs, SKU, and Product Status are all available. Optional Parameter apiPath is the direct url from your baseUrl to your Woo commerce endpoint. Sample imported Affiliate product view in the WooCommerce product page, Add to Cart button has been replaced with a Buy Now button for this type of product. json" file exist. Variable Products Created as Simple Products. WP All Export will show the number of orders available to export. json (lets call it temporary. Go to the Home page of the StoreRobo Product Import Export App. cs_1uab8h3s3op. With the plugin, you can call virtually any REST API and import the data within that API and then create WooCommerce simple products from this API data. The WooCommerce API Manager has a built-in tool to import WooCommerce Software Add-on data into the API Manager. With help of cron and the REST API of wordpress, I can update stock almost realtime. This extension also works with WooCommerce Subscriptions (separate purchase) to add additional pricing to the recurring subscription. Step 5: Run the Import. Unless you’re a developer, in most cases the integration you’re working with will only require you to generate API keys for you to enter in their system, and you’ll be connected to the external service! This document covers the basics of using the REST API from a merchant perspective. Seamlessly integrate with the HOPS framework for optimized workflow and improved performance. So, to store new products that way, you will have to do something like this : To add new product in the wp_post table: From the WordPress Dashboard: Go to: Products > All Products. For the final step, download the “Printify for WooCommerce” plugin. It works fine for my usecase but I need to do the same through my command line or programatically. I have also checked the Woocommerce CSV Export/Import. Mar 13, 2021 · Set a custom User-Agent, default is WooCommerce-Python-REST-API/3. Feb 24, 2018 · the permission to make requests to the new WP-REST API integration, which is available since WooCommerce 2. After registration and logging in; open the “My Profile” from the top menu. ShipStation is a great fit […] Approach 2: Sync Amazon and WooCommerce Using Free Product Import Tools. json and in next run check if the "temporary. You switched accounts on another tab or window. id:100, SKU101. Now click on AliExpress to access the plugin. It empowers you to segment your product CSV into separate files for normal products and variations. Using the API to Posts plugin from WPGetAPI you can create posts, cu Product Add-Ons allows you to add paid or free options to your products using several field types including radio buttons, checkboxes, drop-down fields, custom text inputs and more. The current WP REST API integration version is v3 which takes the first-order position in endpoints. This is the recommended way to get products from WooCommerce as it is more flexible and powerful than the other methods. 4/ Select Choose File and then upload the CSV file you downloaded from Etsy in Step 1. It has opened up a whole new client base for me. Matrixify app uses WooCommerce API to get your shop data. v3 includes category thumbnails with requests for product/categories. You’ll be taken to Export products to a CSV file. WP WC CLI Create Product. Step 4: Configure the Import Settings. Next, connect your WooCommerce store to Printful using thePrintful for WooCommerce plugin. 4. When importing new products, a new option If product ID conflicts with an existing Post ID appears. Dec 4, 2020 · Combining this topic Update WooCommerce product price and stock combined with fgetcsv and fopen. Click on the check box to enable the scheduler to auto-import the products from Shopee to WooCommerce. Choose the user account with which the key will be associated. Using the tool, you can streamline your entire selling process across platforms and maximize your reach to millions of potential customers. Supports custom fields. Export and import your WooCommerce products (simple, grouped, external/affiliate) in a super simple way using CSV files. You can find a few free tools to sync Amazon and WooCommerce. Jan 17, 2023 · In order to import products from Printful to WooCommerce, follow these steps: First, create an account with Printful. (It will show you the Website name where your products will be added) Step 1: From your Shopify admin, go to Products > All products. Our API to Posts plugin allows you to sync products from an API to WooCommerce products on your WordPress website. Step 1: Import WooCommerce Products by uploading CSV file. Installation Setup and Configuration Product Add-Ons allows you to add […] At the WooCommerce admin panel go to WooCommerce > Settings > Shopify to WooCommerce for configuration. Upload the CSV file containing the product feed data to import. Choose Select import type and upload your . Choose Quick import as the import method and select an ‘import from’ location. Click Choose File and upload the CSV file you just created. Has a free Chrome extension. Before you start importing your products into your WooCommerce store using the WP All Import plugin, we recommend considering the following best practices for optimal use of the tool: First, make sure that you have a product list with products that are ready to be sent to your store (you can learn more about creating product lists here ). Note that Excel file import is supported for Advanced Import as well. The Migrate WooCommerce to Shopify plugin transfers data from WooCommerce to Shopify using the Shopify API key, so you can be Parameter consumerSecret is the consumer secret provided by WooCommerce, e. The integration extension from CedCommerce will help sellers export product details and other crucial information from their WooCommerce Store to eBay and import their eBay Products to WooCommerce. The WooCommerce add-on for makes it easy to bulk import your products to WooCommerce in less than 10 minutes. Now let us create a product: Jun 15, 2020 · ⚡ Go check out LearnWoo - https://learnwoo. Choose the post type as Product. About A PHP script to import products and variations from JSON to WooCommerce using the WooCommerce REST API To create or manage keys for a specific WordPress user, go to WooCommerce > Settings > Advanced > REST API. An Import Products screen appears. v3 deprecated the product/sku/<id> endpoint (because a SKU can be generated with any character and there is a filter, filter [sku], that covers this use case). In the Drag & Drop screen, map your import data elements to the fields displayed in the various sections other than the Custom Fields section. You’ve finished linking your WooCommerce store! Now, you can publish products to your WooCommerce store and Sep 6, 2023 · A quick 2 minute video showing you how to create WooCommerce products using the ASOS API. Sep 12, 2022 · Follow the steps below to export the products from your source store: Go to your source store’s WooCommerce Dashboard. Checkmark Advanced Export and click Filter data. Reload to refresh your session. Creating a product with the REST API. Map the columns in your file to the appropriate product fields in WooCommerce. Run the import manually to verify that it works (the last thing you want to do is schedule an erroneous import). Woo Import Export. Mar 27, 2024 · To connect the Shopify store to the WooCommerce site: From the Shopify admin dashboard, click on Apps > SR Product Import Export > Home. With only 2 steps your Shopify products (including images) and categories will be migrated. You signed out in another tab or window. Dec 13, 2023 · After the upgrade, I can no longer use the Rest API to query all products in an order. Setup and Configuration Note: Before entering your credentials, you must request access to the Synnex XML API from your Synnex Sales Representative if you have not already done so. ”. Select All content. from woocommerce import API wcapi =… [This thread is closed. Click the Import button to begin the transfer of product data into your store. Oct 25, 2022 · If importing a boolean value (true or false) use 1 or 0 in your CSV. Step 1: Create an Order Export. 1, the request key has been changed to wc_am_action. Continue. Click on ‘Continue’ to proceed with the import. Select the file and click import test. Import External/Affiliate Products. You can also get products from WooCommerce by using the WC_Product_Query class. S2W – Import Shopify to WooCommerce helps you migrate data from Shopify to WooCommerce easily. Hopefully, these WooCommerce Product Import Plugins could be useful to you when you are creating a new WooCommerce site. com/channel/UCmH3_XqDsKPnXkl2nZ_UtSw?sub_confirmation=1Exp Feb 17, 2020 · Now we got a new requirement: We should include products from an external provider using their API. Step 1: Understand How Product Migration Works. 0. Step 1: Create a New Product Import. Nov 23, 2023 · Step 1: Upload the Product Data File. Easy solution that we use in our plugin is splitting the import in multiple steps and calling the cron more often. com/⚡ Go subscribe to our channel - https://www. Convert images to large : sometimes eBay API provide higher quality images, use the feature to import such images if they are available. Products Product Properties Attribute Type Context Description composite_virtual boolean read write Forces all contents of this composite product to be treated Description. Paste that Site key in the Target Website Key Field and Save it. Upload CSV file to import product data in bulk. If you have a WooCommerce store and want to sync (add/update/delete) the products from the external inventory warehouse/ store’s platform via APIs then it can be using the CUSTOM API plugin along with our Woocommerce products sync from external APIs. Connecting to WooCommerce site. Enter a description for the key (e. e. com. Nov 1, 2023 · To import products from an XLS or XLSX file to your WooCommerce store: Go to WebToffee Import Export (Pro) > Import from your WordPress admin panel. This will open up the Product Importer page. From there, you’ll see an option to import sample products. Now you need to select these values to schedule an automatic import from Google Sheets into WooCommerce: Tick the Run this in the future checkbox. You can generate consumer secret and consumer key in the WordPress backend under WooCommerce › Settings › API › Keys/Apps. Under Import Products, select WooCommerce API. Import Variable Products. Explore the enhanced capabilities of our latest plugin with HOPS compatibility. Notice two upload sections; Import Product CSV and Import Product Variations CSV. Enter your Printful API keys into the plugin settings page. Click the "Add Key" button. To add new products to WooCommerce or even to make a single adjustment, you must go through a long-form (product edit page). Import data from your API & easily create custom posts or simple WooCommerce products within WordPress. The original intent of the API Manager was to provide API Key management, and software updates, for WordPress plugins and themes, however, over time this evolved to allow use cases for Use WooCommerce Dropshipping to send automated order notification emails to your wholesale dropshippers when new orders arrive via your WooCommerce store. Simply enable the import cron to begin the process. Nov 23, 2021 · 2. As you click on the connect to store Jul 26, 2023 · 3- Import WooCommerce products from Google Sheets. 0a: wp_api: bool: no: Set to False in order to use the legacy WooCommerce API (deprecated) To import the product images via media library: Upload the images in the Media library from the admin panel. Import WooCommerce Products - Table of Contents. Composite Products extends the /products/ and /orders/ endpoint responses with additional properties that are documented in this guide. See changelog for details. Why this method not allowing to export all products in XML format. Copy the image name: formal-shoe. , "Sync API Key"). Mar 6, 2024 · Download this plugin and goto Dashboard. Paste the Consumer Key, Consumer secret and provide the server name. g. Next, you should be able to push products on WooCommerce and update product details such as descriptions, prices, images, or quantities. Steps 1 to 3 is required for first interaction and for further product import you only need follow the last one (Step 4) . Woo Export-Import is a lightweight, quick, responsive, and easy-to-use plugin. Make changes to the CSV using spreadsheet software and save as a plain text CSV. Use these instructions to create a WooCommerce product import. Any help in this regard is highly appreciated! TIA! TD SYNNEX Price and Availability For WooCommerce Documentation. Aug 31, 2023 · To access the Woocommerce Import Sample Products feature, you’ll need to have Woocommerce installed on your WordPress site. Click WebToffee Import Export (Basic ). Quick start guide. Auto Import Products. To import WooCommerce orders: Navigate through the menu: WooCommerce > Import Export Suite and click on the tab: Import. youtube. Drag & drop the data from your XML or CSV into the WooCommerce Step 3: Open the Amazon product page that you want to import into your WooCommerce store in the same Chrome browser in which you have previously installed the supporting Chrome extension. Go into your WordPress Admin -> WooCommerce -> Settings -> Advanced -> Rest API -> Add Key. Make sure that the post type field is set to “WooCommerce Product”. XML file containing your Alibaba product data. Upload the parent product first; click Import Products, Browse to select the CSV file, and. You can get these details after creating the 3/ Click the Import products button. Here you will find the four tabs, API Settings, Import Settings, Run Import and Import Status API Settings In API settings, you can provide your Shopify store address, API key and API Secret Key. The seller can manage the orders from a centralized order management dashboard and begin selling on eBay. The first thing we will need is API credentials that Matrixify can use to access WooCommerce data. Step 2: Review the Import File. Navigate to WooCommerce > Settings > Advanced > REST API. Then you need to open the Import tool. Make sure to select Download a file > From URL or Download a file > From FTP/SFPT as your import data source. If referencing an existing product ID, prefix the id with id:. Once you’re in the products spreadsheet, open the Import tool. As of version 2. These are fields that our plugin fully recognizes and supports, regardless of whether they are custom Apr 12, 2022 · To do this, take the following steps: From your WordPress dashboard, go to Products > All Products and click the Import button at the top of the page. More information at: Install and Activate Plugins/Extensions. The first step is to be able to list your products on multiple platforms. Apr 15, 2017 · WooCommerce REST API – Import products from JSON. An example : "/wp-json/wc/v3/" This is useful if only you changed your default Wordpress Woocommerce path, otherwise default applies. Go to the site to which you are moving the content and navigate to Tools > Import. The left side of the plugin looks just like WooCommerce, and the right side displays a product from your XML/CSV file. Steps to import orders. Step 4: Download the “Printify for WooCommerce” shipping plugin. Next, click Select an Export method. Step 4: Confirm That the Products Migrated. You need to go to WP Sheet Editor > Edit products to open the products spreadsheet. To define which export columns to include in the export, click on Customize Export File. 6/ Use dropdown menus on the right side to adjust fields or To export an XML file containing product data: Go to: Tools > Export and choose the content you wish to migrate. To add a name, title, description, alt text, or any other details to an image, simply specify them in the images Dec 15, 2022 · WooCommerce is a popular e-commerce platform that allows users to create and manage online stores. the version of the API. Click on Connect to finish. Map your API data to custom fields, tags, categories, images and more. Click on “Run the importer”. Postman is recommended for remote API testing. Import link and Secret key is required to connect the Aliexpress Product Importer WooCommerce extension with Chrome extension. The example CSV uses default column headers, so the Jul 17, 2016 · The Wordpress Woocommerce stores products informations in wp_post (post_type = product) and in wp_postmeta (meta_key and meta_value for a post_id). Supports product variations and hierarchical categories, so you can import even the most complex listings with ease. ] Skip to content WooCommerce Software Add-on. 5/ Continue. WooCommerce Dropshipping also generates a […] Mar 22, 2024 · Connecting to WooCommerce site and Importing products. It groups ordered products by supplier, and then sends them to each supplier with a list of products purchased from them. Register on https://importwoocommerce. Make your selections, then click Generate CSV. Use a dedicated solution to import Amazon products like the paid Amazon Product Importer & Affiliate plugin. Please ensure your store and database Import all active listings from eBay and recreate your eBay store categories in WooCommerce. From the Products menu in your dashboard select Price and Stock Import. jpg. To connect the Shopify store to the WooCommerce site: From the Shopify admin dashboard, click on Apps > SR Product Import Export > Home. From here, you can select which columns, what product types, and what product category you want to export. Go to WooCommerce > CSV Import Suite > Import Products. Thought it might be worth sharing with others because I couldn’t find much information about products import from JSON using the API. Set a custom User-Agent, default is WooCommerce-Python-REST-API/3. Don’t import images from the description: If you want to skip images from the product description and don’t import them to the wordpress media library, use this option. 6. Under the templates section, you can map your WooCommerce product categories with the Etsy categories. You can change the Secret key (any random string) any time if needed. Feb 1, 2024 · For correct product synchronization, you need to follow a set of specific tasks and functions. dominykas April 15, 2017 107 Comments. If it’s not, select it from the dropdown menu. Before moving on to the app’s next section, click the save settings button. Once you have Woocommerce installed, you can go to the “Tools” section of the Woocommerce menu and click on “Import”. It allows us to create, read, update and delete the products using the requests in JSON format. Also, you can export or import all kinds of product categories, users, and orders with this plugin in just a few clicks. Multiple values in a field get separated with commas. If you are migrating the store as a whole, we recommend you to import the data in the following the sequence : User/Customer > Product > Product reviews > Coupons > Order. After checking which group is the product, it gets the data so I can update the stock. These functions can be added to your WooCommerce store for $79 per year. 6 added support for REST API endpoints based on the WordPress REST API infrastructure. Once you’re ready to connect all of your Amazon inventory into WooCommerce, you need a tool that will sync your listings, sales, shipping, and other factors. Step 4: Locate your CSV file, then click Open. Change FILE_TO_IMPORT to your JSON file name and WooCommerce API credentials. Import products from Etsy: The solution also imports products from Etsy to your WooCommerce store. CSV or . 0: oauth_timestamp: integer: no: Custom timestamp for requests made with oAuth1. CedCommerce’s Etsy Integration allows you to handle orders from your Etsy store right within your WooCommerce orders section. In the next screen, add a description and select the WordPress user you would like to generate the key for. miniOrange WooCommerce Product Sync Integrator allows user The Product CSV Import Suite has been designed to seamlessly integrate with the default product types that come with WooCommerce. It is In GoDataFeed > Products > Import Source drop-down, select WooCommerce. Keep posts & products in sync with your API by setting the automatic sync interval from anywhere between 5 minutes and a Skip import of new products: To skip the import of new products, choose “Yes”. Select Products from the drop-down menu. Step 5: Click Upload file. This plugin will seamlessly apply the correct Printify shipping rate to your Printify products. When importing the file I need to update each already existing product by matching the Name of the product. Otherwise, to migrate everything, click . Click on Proceed to import. In the input CSV file, specify the image name against the corresponding product. Once you’ve uploaded successfully your CSV file, you will receive a confirmation email from Shopify. Amazon for WooCommerce is a powerful tool that allows you to effortlessly connect your WooCommerce store with the largest e-commerce platform i. May 8, 2022 · WooCommerce is the most popular eCommerce platform to build any type of online store. Click on the “Import” button Dec 7, 2023 · Steps: From your Woo Commerce admin, click Tools > Export. Click Download Export File. A Column Mapping screen appears. Next, you will see the Connect to store button, as shown below in the screenshot, which is the one-click authorization step for connecting WooCommerce store with AliExpress. May 8, 2024 · Once installed, activate the plugin and go to WooCommerce > Import. If so use it. This comprehensive solution offers seamless inventory syncing, centralized order management, bulk […] Steps to Import Custom Fields to WooCommerce Products. Click the check box to enable the scheduler events for importing products from Shopee. You can use the same app to get the product data exported in a CSV file. ShipStation is a web-based shipping service that streamlines the order fulfillment process for online retailers, handling everything from order import and batch label creation to customer communication. Fill the Import link and Secret key that appears in your Amazon Product Importer WooCommerce extension configuration page. Match products by their: ID, SKU. Custom meta is supported/imported but only plain text - no support for JSON or Serialised data. An XML file is downloaded to your computer. I exported XML file from Woo commerce>Tools>>Export>All Content. Our ShipStation extension helps you get your orders from WooCommerce with ShipStation and expedite the shipping process as part of your order fulfillment steps. Select Export. The plugin uses Shopify API key to transfer data from Shopify to WooCommerce store directly, your data is kept private. Templates. In the Drag & Drop screen, in the Attributes tab of the WooCommerce Add-On section, use the Add Attribute link to create one attribute for every attribute that you intend to import. WooCommerce 2. Open Chrome extension popup. Step 2: Create an Export Bundle. Scheduler. Click the ” Download Export File ” button. For a single store, you can buy this plugin at $99. Category Mapping ↑ Back to top Step 2: Install and configure the Aliexpress Product Importer WooCommerce extension you purchased from the WooCommerce Extension Marketplace. Option to import product as Simple, Variable or Affiliate. For product syncing, you'll need read/write Sep 28, 2021 · 1. Your dropshipping partners can then ship orders to customers. Create a WooCommerce product import as per these instructions. Step 3: Import the Bundle File on the Destination Site. (I know there is an option for matching the SKU or ID but Jun 21, 2021 · Allows Amazon products to be imported into your WooCommerce store as configured options in just one click. The problem is that I do not know how to update the stock of WooCommerce in this way :O And I'd like to have that verification was done when the Jan 18, 2019 · I need to import more than 100 products from an CSV file but some of the products already exists in the webshop. An attribute consists of a pair of fields: Name Jul 5, 2022 · In your WordPress dashboard, go to WooCommerce → Products and click Export at the top of your screen. Go to the WooCommerce admin panel and select the Marketplaces menu from the left sidebar. Shoppe Integration for WooCommerce ensures your inventory levels are always up to date across platforms. To import new products from the input file, choose “No”. WP WC CLI FAQ Regarding Category Text. Advanced Topics. So for importing your vendors products into your WC you can use the provided REST API. Auto-Publish Listings: Create, edit, or delete listings on WooCommerce and have them API Documentation. Select WordPress and follow the instructions. You can add your products manually ( Products → Add New ) or by importing them into the appropriate tables on the MySQL database for your WordPress site. In the Column mapping, map the fields by aligning the field titles with column titles. Bulk Product Sync with Google Sheets™ is a creative, quick, and easy way to use Google Sheets™ to bulk update or create products and categories for your WooCommerce store. Item specifics on eBay will become product attributes in WooCommerce, making it easy to manage your listings and make changes as needed. Next is the Map Fields screen. We don't want to store the data to the WP database as these Jul 15, 2020 · wooCommerce Rest API - Add Product. Then click Upload File (import file). Once done with all the settings, hit the ‘Save Setting’ button. It should be possible for customers to buy the products from our shop that is just integrated via the API. You signed in with another tab or window. The Column Mapping screen will display, and WooCommerce automatically attempts to match or “map” the Column Name from your CSV to Fields. Those are real and digital products and are not listed in our WP backend. Real-time Data Sync. Steps to Automatically Import WooCommerce Products. I have a custom field that has the url source to each product and I want to use it as a parameter to the api. Under the Import Products section, select the Local tab. Order Management: Efficiently process orders with seamless import into your WooCommerce dashboard, backed by Shopee’s order API for user data protection. Scroll down and click the button to “ Run the Apr 9, 2024 · To recap, here are three ways to import WooCommerce products with images: Use the WooCommerce built-in importer tool. The API Manager can also answer API queries intended for the WC Software Add-on, so it is safe to delete the WC Software Add-on once the data import has been completed. Click on Connect. Furthermore, the following extensions have been tested to work with Product CSV Import Suite and are officially Sep 6, 2023 · Go to WooCommerce store dashboard → Products. eBay Integration for WooCommerce. WooCommerce Products sync via External API | Import products in WooCommerce using Supplier APIs. WooCommerce has an integrated WordPress REST API. csv file you downloaded. Choose the permissions for the key based on what you'll be using it for. Navigate to All Export › New Export on the export site, then select WooCommerce Orders from the dropdown list. WooCommerce maps columns from the sample CSV automatically. If referencing a SKU, no prefix is needed. My goal is to update the stock of the products on a woocommerce website from a csv file. Keep Same Product ID When Migrating Products. Enter the following information: API path: The secure URL of your WooCommerce store's API location; use HTTPS. Easily link import file fields to your WooCommerce product fields. Select the Import tab. v3 introduces new product attribute endpoints ( GET, POST, PUT and DELETE ). Not only does it support product import, but this plugin also comes with an export module. Perform the installation steps above. Jul 3, 2017 · I don't think you can connect Woocommerce to your vendors database directly. Note: Keys/Apps was found at WooCommerce > Settings > API > Key/Apps prior to WooCommerce 3. Amazon. Steps to Import Product Attributes in WooCommerce. 0a: wp_api: bool: no: Set to False in order to use the legacy WooCommerce API (deprecated) Sample Walmart imported product view in the WooCommerce product page. This will open a page where you can generate new API credentials. 650. Open Amazon Settings and copy the Site Key. Inventory updates, syncing products, data filtration, and automatic column mapping are some of the main peculiarities of this product importer plugin. Click the Choose file button to locate the CSV file you just created on your computer. With the latest update, we have integrated ChatGPT API with our plugin. Consumer Key: The unique value that identifies your WooCommerce store's API. Create a new WooCommerce product import. I will be using the core importer tool that comes with Woocommerce. Here, one can either Skip an item or Import as a new item. 2. Secret Key: The secret key used to access your WooCommerce store's API. I had a task to create a PHP script to import simple and variable products from JSON file using the WooCommerce REST API. Select Choose file and then select the sample-products. Make a working copy of data. Step 2: Click Import. Use a dedicated WooCommerce importer plugin like Product Import Export for WooCommerce. Oct 1, 2022 · The most common way to get products from WooCommerce is by using the WP REST API. org WooCommerce Products & WordPress Posts from APIs. Jan 8, 2024 · Import through CSV file, url or FTP. The XML file contains only few products but not all products which are approx. Go to the ‘Products’ page in WordPress and click on the ‘Add New’ button. Click the "Add Key" button to create a new API key. click Upload file and import. Upload a CSV file from your local storage containing the product data. This class allows you to query for products in a number of ways Jul 28, 2023 · Go to WP Sheet Editor > Edit products to view and manage your WooCommerce products in the spreadsheet. iw lk mh pu nu hj nh bl ox yi