Alejandro Aranda

Are these images accessible from your server? Many times the problem is that the server does not have external access to the internet.

Regarding the categories in the products it is rare, it should work, but without knowing how your Oscommerce is structured I can not tell you more.

I don’t know what can happen, the totals are being calculated from the oscommerce database through:
‘_order_total’ => $ totals [‘ot_total’] [‘value’]

Search ot_total in your oscommerce database to see if it is filled.

But I don’t know if the tax configuration or other oscommerce field is affecting the total.

In the root folder of your wordpress site there must be some log files of the import, could you tell me what appears in the product images?

The problem is that oscommerce files are not accessible from the wordpress.

You can test if you have access with this script: https://www.saotn.org/php-curl-check-website-availability/

The script https://www.yoursite.com/website-test.php that you have linked me to check the oscommerce site says “https://www.yoursite.com is down!” that is that it is not accessible from yourwordpresssite.com you must contact the hosting of your site and ask for this.

Another option is that you mount a local web server on a PC, with a copy of both sites and do it locally. Once you have made your import, pass it to the web server https://www.yoursite.com

One last option is to copy the catalog / images folder on the woocommerce server, on the server url parameter of my plugin to put on the woocommerce server, in this way we make sure that your server has access to those images.

• This reply was modified 5 years, 8 months ago by Alejandro Aranda.
• This reply was modified 5 years, 8 months ago by Alejandro Aranda.

This happens because the processing time of a script on your server has been exceeded, do not check all the options when importing.

If you have too many products you can use limit and offset to split the import into pieces.

You can also try to increase the limit of PHP execution.
https://stackoverflow.com/questions/16171132/how-to-increase-maximum-execution-time-in-php

to make the connection from the wordpress server, this must be accessible to the oscommerce server database, has anything changed in the configuration of any of them?

Try creating this script in a test.php file on the WordPress server, with the data of your connection to the oscommerce mysql, to rule out the problem of the servers.

Running at http: // [yoursitewordpress] /test.php

<?php
  $conn = new mysqli("localhost(or ip of mysql server, if a diferent host)", "user", "password", "databasename");
  
  if ($conn->connect_error) {
    die("ERROR: Unable to connect: " . $conn->connect_error);
  } 

  echo 'Connected to the database.<br>';

  $conn->close();
?>

• This reply was modified 5 years, 9 months ago by Alejandro Aranda.
• This reply was modified 5 years, 9 months ago by Alejandro Aranda.
• This reply was modified 5 years, 9 months ago by Alejandro Aranda.

The plugin transfers customers, products, even orders. If you do not have enough knowledge, I recommend that you contact someone who does.

Desde la versión del plugin 2.0.6 se incluye Products weight

Actualmente no dispongo de tiempo para hacer desarrollos externos a mi trabajo actual, entiendo que necesitarías un desarrollo propio, para este tipo de tareas creo que Prestashop ofrece más posibilidades que Woocoommerce, ya que tiene una estructura de Base de Datos más consistente.

I have not tried it yet, but there should not be any problem.

Sorry, but I’m on a business trip in Qatar, and I have not had time to answer, sometimes the problems with the images is that the URL of these images are not available from your wordpress server , the best thing is to make a copy in a local Lamp that has access to the internet and do it from there. since many hosting have access restrictions outside their host.

I currently have time to improve the plugin, I will try to do a test but I can not guarantee anything.

The truth is that the part of the attributes, the inheritance of the previous developer of the plugin and I have not had time to analyze it, possibly have something that is missing but should create the products correctly.

This is the code.

` if ($attributes = $oscdb->get_results(“SELECT po.products_options_name, pov.products_options_values_name FROM products_attributes pa, products_options po, products_options_values pov WHERE pa.products_id='” . $product[‘products_id’] . “‘ AND pov.products_options_values_id = pa.options_values_id AND pov.language_id=po.language_id AND pa.options_id=products_options_id”, ARRAY_A)) {
wp_set_object_terms($product_id, ‘variable’, ‘product_type’);
$attrib_array = array();
$attrib_combo = array();
$max_price = $product[‘products_price’];
$min_price = $product[‘products_price’];
foreach ($attributes as $attribute) {
$slug = sanitize_title($attribute[‘products_options_name’]);
$attrib_array[$slug] = array(‘name’ => $attribute[‘products_options_name’],
‘value’ => ltrim($attrib_array[$slug][‘value’] . ‘ | ‘ . $attribute[‘products_options_values_name’], ‘ | ‘),
‘position’ => 0,
‘is_visible’ => 1,
‘is_variation’ => 1,
‘is_taxonomy’ => 0);
$attrib_combo[$slug][] = array($attribute[‘products_options_values_name’], ($attribute[‘price_prefix’] == ‘-‘ ? ‘-‘ : ”) . $attribute[‘options_values_price’]);
}
// Now it gets tricky…
$combos = otw_cartesian_product($attrib_combo);
foreach ($combos as $combo) {
$variation_id = wp_insert_post(array(
‘post_title’ => ‘Product ‘ . $product_id . ‘ Variation’,
‘post_content’ => ”,
‘post_status’ => ‘publish’,
‘post_type’ => ‘product_variation’,
‘post_author’ => 1,
‘post_parent’ => $product_id
));
$opt_price = $product[‘products_price’];
$special_price = $special[‘specials_new_products_price’];
foreach ($combo as $k => $v) {
update_post_meta($variation_id, ‘attribute_’ . $k, $v[0]);
$opt_price += $v[1];
$special_price += $v[1];
}
update_post_meta($variation_id, ‘_sku’, $product[‘products_model’]);
update_post_meta($variation_id, ‘_regular_price’, $opt_price);
update_post_meta($variation_id, ‘_price’, $opt_price);
update_post_meta($variation_id, ‘_thumbnail_id’, 0);
update_post_meta($variation_id, ‘_stock’, $product[‘products_quantity’]);
if ($special) {
update_post_meta($variation_id, ‘_sale_price’, $special_price);
if ($special[‘expires_date’] > time()) {
update_post_meta($variation_id, ‘_sale_price_dates_to’, date(“Y-m-d”, $special[‘expires_date’]));
update_post_meta($variation_id, ‘_sale_price_dates_from’, date(“Y-m-d”));
}
}
if ($opt_price > $max_price) {
$max_price = $opt_price;
}
if ($opt_price < $min_price) {
$min_price = $opt_price;
}
}

I have yet to update the function that uploads the images, which does not duplicate the already exist in the library.

With respect to the other of the attachments I do not understand very well what you mean.

Not yet, The management of multilanguage in WordPress, is done through third-party plugin as polylang https://es.www.ads-software.com/plugins/polylang/