Migration to v4 error

[astecme]

I am trying to upgrade an old phoenix install.

I have the old site in My_Domain/shop

I have the new site in My_Domain/trucking

if I go My_Domain/trucking  I get --> Please check Authorization topic in readme file.

if I go My_Domain/trucking/admin  I get --> requirements.php

 

Where have I gone wrong?

[astecme]

Just thought, should the new site be in---->  My_Domain/shop/trucking/   ??

[osCommerce-Official]

@pandrei could you please help here? Thank you!

[pandrei]

3 hours ago, astecme said:

Just thought, should the new site be in---->  My_Domain/shop/trucking/   ??

It seems you unzipped oscb157.zip into My_Domain/trucking folder, isn't it?

If it is right, its is not new site. It is osCommerce Bridge that is used then you are migrating to new site and you should move it to My_Domain/shop/trucking/

I suggest you read our wiki:

1. How to install new site:

2 How to import from existing osCommerce 2.x:

https://www.oscommerce.com/wiki/Importing_Data_from_Older_osCommerce_Version_to_New_One

 

[astecme]

5 hours ago, pandrei said:

It seems you unzipped oscb157.zip into My_Domain/trucking folder, isn't it?

If it is right, its is not new site. It is osCommerce Bridge that is used then you are migrating to new site and you should move it to My_Domain/shop/trucking/

2 How to import from existing osCommerce 2.x:

https://www.oscommerce.com/wiki/Importing_Data_from_Older_osCommerce_Version_to_New_One

 

I have tried both the location My_Domain/trucking/ and My_Domain/shop/trucking/ and get the same result.

I have tried to follow the "Importing Data from Older osCommerce Version to New One". Do I need to do a fresh install first?

[pandrei]

14 hours ago, astecme said:

I have tried to follow the "Importing Data from Older osCommerce Version to New One". Do I need to do a fresh install first?

Of course, you have to install a new version before importing.

14 hours ago, astecme said:

I have tried both the location My_Domain/trucking/ and My_Domain/shop/trucking/ and get the same result.

It's the right result, the bridge will be used from a new osCommerce version.

[astecme]

@pandrei with your help I have an installation of the OsComm V4 on a different server (was planning on moving anyway). Now I am stuck with "Oscommerce Connector Service"; I get the following error:-

Error while establishing connection: file_get_contents(https://www.astecmodels.co.uk/shop/trucking/index.php?): Failed to open stream: HTTP request failed! HTTP/1.1 401 Unauthorized

The bridge software is installed in /shop/trucking/ location.

[pandrei]

23 hours ago, astecme said:

Error while establishing connection: file_get_contents(https://www.astecmodels.co.uk/shop/trucking/index.php?): Failed to open stream: HTTP request failed! HTTP/1.1 401 Unauthorized

You have to follow the steps starting from 4 in this instruction:

On 8/11/2023 at 6:02 PM, pandrei said:

2 How to import from existing osCommerce 2.x:

https://www.oscommerce.com/wiki/Importing_Data_from_Older_osCommerce_Version_to_New_One

[astecme]

25 minutes ago, pandrei said:

You have to follow the steps starting from 4 in this instruction:

It is step 19 that I get the error I have shown.

[pandrei]

1 hour ago, astecme said:

It is step 19 that I get the error I have shown.

1. Please re-check the secure key that you got on step 15 and secure key that you paste in Connector Service:

2. Try to change secure method in the above field

 

[astecme]

@pandrei Both the POST and GET work, just BEARER TOKEN does not. Only issue is both seem to hang when import products at about between 50 to 75% and on orders gets about 30% the way through. Any advice on sorting this?

And Finally the is no option to Import Order Statuses. Am I missing something?

[astecme]

Also just looking through the products imported, the ex-VAT has been set as the inc-VAT. I am re-checking everything to make sure I have not missed something.

[astecme]

Further investigation shows that the website is not adding the 20% Vat, even though I think I have set it up right. Please can you advice or point me in the right direction? I am happy to supply access to admin area if it helps?

[pandrei]

13 hours ago, astecme said:

Both the POST and GET work, just BEARER TOKEN does not.

Use the POST method then.

13 hours ago, astecme said:

Only issue is both seem to hang when import products at about between 50 to 75% and on orders gets about 30% the way through. Any advice on sorting this?

Could you send me the logs from:

1) osCommerce v4 -> Admin -> Settings -> Tools -> Error log viewer -> Download all logs

2) lib/common/extensions/OscLink/logs/*.log

13 hours ago, astecme said:

And Finally the is no option to Import Order Statuses. Am I missing something?

You have to map old Order Statuses and new Order Statuses manually in the Mapping tab. If can't find appropriate Order Status, you can add new one in Admin -> Settings -> Order Status -> Order Status

12 hours ago, astecme said:

Also just looking through the products imported, the ex-VAT has been set as the inc-VAT. I am re-checking everything to make sure I have not missed something.

The product price is imported as is. Usually it is ex-VAT.

1 hour ago, astecme said:

Further investigation shows that the website is not adding the 20% Vat, even though I think I have set it up right. Please can you advice or point me in the right direction?

Could you show the screenshot from your product price like this:

1 hour ago, astecme said:

I am happy to supply access to admin area if it helps?

Sure, it helps. You can send me in pm.

 

[astecme]

@pandrei sent you pm with log in. Also noticed I only have gross price and no net price option, and in the gross price is my net price.

[pandrei]

1 hour ago, astecme said:

sent you pm with log in. Also noticed I only have gross price and no net price option, and in the gross price is my net price.

Product Id: 94 Model: 56335

Front:

Is it right?

23 hours ago, pandrei said:

Could you send me the logs from:

1) osCommerce v4 -> Admin -> Settings -> Tools -> Error log viewer -> Download all logs

There is no errors in these logs

23 hours ago, pandrei said:

2) lib/common/extensions/OscLink/logs/*.log

Still waiting for these logs. I could not get it from admin area.

Also check your apache logs or ask them from your host provider.

[astecme]

3 hours ago, pandrei said:

Product Id: 94 Model: 56335

Front:

Is it right?

There is no errors in these logs

 

@pandrei I found under the configuration of the theme "Tax Class" and assigned that. That obviously sorted that out.

[pandrei]

18 minutes ago, astecme said:

I found under the configuration of the theme "Tax Class" and assigned that. That obviously sorted that out.

Not exactly. I reset to default some configuration keys you changed.

4 hours ago, pandrei said:

2) lib/common/extensions/OscLink/logs/*.log

Thanks for the logs. I did not see any errors in the logs.

It seems the import script was terminated by the server. Do you have access to the Apache logs? There should be a reason why the script was terminated.

Also try to increase memory_limit php setting to 512M

You can change it in root .htaccess

and root .user.ini

After that try to re-import products

[astecme]

I have found the following about the server I am moving to, could this be the reason?

https://help.krystal.uk/web-hosting/how-to-disable-lite-speed-connection-timeouts

[astecme]

7 hours ago, pandrei said:

Product Id: 94 Model: 56335

Front:

Is it right?

I have checked some of the other categories and they are not, is it something I can correct?

[astecme]

@pandrei is there any way to to get the import part of the inventory at a time to get it all in the new site?

And any reason why some categories are showing price right and some wrong? 

Also tried the changes to increase the memory as you said and did not change.

Edited August 17, 2023 by astecme

[astecme]

@pandrei I do not know if it is of relevance or not but the migration of the orders database and the products stop at 15 minutes. 

[pandrei]

On 8/16/2023 at 4:39 PM, astecme said:

I have found the following about the server I am moving to, could this be the reason?

https://help.krystal.uk/web-hosting/how-to-disable-lite-speed-connection-timeouts

Yes, it could be the reason.

On 8/16/2023 at 11:11 PM, astecme said:

I have checked some of the other categories and they are not, is it something I can correct?

Please give us more details. Screenshots or product ids. for example.

On 8/17/2023 at 10:28 PM, astecme said:

is there any way to to get the import part of the inventory at a time to get it all in the new site?

You can create our hosting  (its free for 2 months), import your old site and then move a database on your hosting.

On 8/17/2023 at 10:28 PM, astecme said:

And any reason why some categories are showing price right and some wrong?

To answer this question I need:

1. products ids with wrong prices

2. files from lib/common/extensions/OscLink/temp/*.*

18 hours ago, astecme said:

I do not know if it is of relevance or not but the migration of the orders database and the products stop at 15 minutes. 

It seems that this time is limited by your hosting provider (you gave the link above)

[astecme]

On 8/19/2023 at 5:27 PM, pandrei said:

Yes, it could be the reason.

Please give us more details. Screenshots or product ids. for example.

You can create our hosting  (its free for 2 months), import your old site and then move a database on your hosting.

To answer this question I need:

1. products ids with wrong prices

2. files from lib/common/extensions/OscLink/temp/*.*

It seems that this time is limited by your hosting provider (you gave the link above)

@pandrei I have done what you recommended about the free trial and that imports fine so I am going export from that into my site. The only question is what did you change to make the products are automatically set to the UK TAX class so I can do that before I transfer data to my site.

[pandrei]

On 8/21/2023 at 5:36 PM, astecme said:

I have done what you recommended about the free trial and that imports fine so I am going export from that into my site. The only question is what did you change to make the products are automatically set to the UK TAX class so I can do that before I transfer data to my site.

1) Open tax_class table and find id of UK TAX

2) Run this SQL:

UPDATE products SET products_tax_class_id = <id_of_UK_TAX>